How can you get Excel to sort numbers with alpha suffixes? Example: 1234A
I need to have Excel sort numericaly and not put the numbers with alpha
characters at the bottom but keep them in order like this: 1234 1234A
1234B 1235.
Thanks for any help.