Menu

alphabetical sort while ignoring preceeding numbers/symbols

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Ron Rosenfeld

Posts: n/a

Default

On Sat, 1 Oct 2005 16:10:02 -0700, "silver fox" <silver
wrote:

Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
characters.

You can use a "helper column". In an adjacent column, insert a formula similar
to =LEFT(A1,2). Then select both columns and sort on the helper column.

--ron

Reply With Quote

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
Count Number of Characters in a cell?	AHJuncti	Excel Discussion (Misc queries)	2	June 16th 05 07:39 PM
Need number of Saturdays and number of Sundays between 2 dates	Class316	Excel Worksheet Functions	1	June 10th 05 02:47 AM
"-" ignored in sort	Mike H	Excel Discussion (Misc queries)	8	January 2nd 05 07:48 AM
HELP! How do you--> Lock a set of rows but also link worksheets to	FRUSTRATED	Excel Discussion (Misc queries)	6	December 29th 04 10:05 PM
How to sort by day and month while ignoring year?	Robert Judge	Excel Worksheet Functions	4	December 23rd 04 11:37 PM

All times are GMT +1. The time now is 04:27 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement