Counting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has a list.
The identifer number is formated as, 432-4102.

I want to be able to group all of the 432, 426 and so on. If I create a new
column, how can I just get the first three numbers.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count until blank cell 2
Row to Column 3
formula required 7
Concatinating two spreadsheets by a column 4
What do I do when using the Large function if 2 entries are the sa 6
How can I pull data from multiple user workbooks into one? 4
suppressing repeated data 3
Dynamically reference a cell based on cell content 1

Back
Top