How can you get Excel to sort numbers with alpha suffixes? 1234A
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. |
How can you get Excel to sort numbers with alpha suffixes? 1234A
Sounds like you need 'helper columns' with something like
=LEFT(A1,4) in one and RIGHT(A1.1) in another The sort using the first and second columns as the 'keys' When done, you can delete the helpers best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "boneified5" wrote in message ... 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. |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com