Sorting data that has both text & numbers.

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

Guest

I have a spreadsheet that has a column that contains both text and numbers.
ex 1, 100, 101, 100A, 111B, 1251 etc. How do I get this to sort where the
alpha letter that follows the # is in # sequence? 100, 100A, 101, 101A etc.
The #'s containing the alpha letters sort at the end. I have tried
formatting the cell, general, number and text and I'm still having problems.
 
Hi,
You will have to insert a column and separate the text
from the number then sort.
- mark
 
Back
Top