Sorting data that has both text & numbers.

[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.

 

[Mark]

Hi,
You will have to insert a column and separate the text
from the number then sort.
- mark