Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 17th 06, 03:41 PM posted to microsoft.public.excel.misc
boneified5
 
Posts: n/a
Default 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.

  #2   Report Post  
Old May 17th 06, 04:02 PM posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 11 February 12th 06 02:38 AM
Sorting Numbers w/Aplha Suffix Moonray80 Excel Discussion (Misc queries) 5 November 21st 05 08:04 AM
Excel needs to let the user set the sort default to "NO HEADER ROW subtleone Excel Worksheet Functions 0 October 8th 05 05:55 PM
Sort Ascending button - Excel 2003 Ann Scharpf Excel Discussion (Misc queries) 0 May 23rd 05 11:11 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 09:37 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017