MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sorting alpha-numeric text


Posted by Andrey on July 30, 2001 2:59 PM

Is it possible to automatically sort numeric and alpha-numeric values in one column that does not result in having all numeric values list prior to alpha-numeric? The following is a typical result that is needed

1850
1850RC
1850S
1950
1975RC
1975S
2000

Thanks in advance.


Posted by Mark W. on July 30, 2001 3:05 PM

Yes, format the column as "Text" before you enter
the values. If you've already entered the values
convert them to "Text" using the Data | Text to Columns...
menu command.