Brad

Posts: n/a

Sort - alphanumeric.

I have numerical data with alphabetical prefixes in a column.

This is what I get when I sort:
C1,C10,C2,C8,R1,R10,R11,R2

This is what I want when I sort:
C1,C2,C8,C10,R1,R2,R10,R11.

How can I do this?

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 can I sort alphanumeric entries by number in excel	beasleyb	Excel Worksheet Functions	1	October 27th 05 10:17 PM
Select rows and sort based on type	Sarah	Excel Discussion (Misc queries)	0	October 11th 05 05:06 PM
Alphanumeric Sort	Ray	Excel Discussion (Misc queries)	5	May 20th 05 08:02 PM
Alphanumeric Sort	Arturo	Excel Discussion (Misc queries)	3	March 2nd 05 06:19 PM
"-" ignored in sort	Mike H	Excel Discussion (Misc queries)	8	January 2nd 05 07:48 AM

All times are GMT +1. The time now is 07:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us