ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can you get Excel to sort numbers with alpha suffixes? 1234A (https://www.excelbanter.com/excel-discussion-misc-queries/89085-how-can-you-get-excel-sort-numbers-alpha-suffixes-1234a.html)

boneified5

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.

Bernard Liengme

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