Posted to microsoft.public.excel.misc

Jackson

external usenet poster

Posts: 8

Help with sorting numbers with text suffix

Need help sorting numeric. Currently sorts:
492947
494537S
49355
495234
5001H
690190
Need 5001H to be at the beginning, then 49355, then 492947 and so on.
Cell, format, column, set as "text" due to last character possibly being
alpha. Help please. Thanks.
Jackson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to add a suffix to a whole column of different part numbers?	Gene's General	Excel Worksheet Functions	2	August 10th 06 07:47 PM
Sorting numbers as Text	David M.	New Users to Excel	6	July 25th 06 05:46 PM
SORTING TEXT AND NUMBERS	jstephenson	Excel Worksheet Functions	5	February 10th 06 08:44 PM
Sorting Numbers w/Aplha Suffix	Moonray80	Excel Discussion (Misc queries)	5	November 21st 05 07:04 AM
Sorting when some numbers have a text suffix	confused on the tundra	Excel Discussion (Misc queries)	5	December 18th 04 10:19 PM

All times are GMT +1. The time now is 03:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us