LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
happy1
 
Posts: n/a
Default How can I sort text (in excel) while ignoring articles (e.g., the

I work in a library and want to sort lists of CD titles. I want to sort the
list alphabetically while ignoring articles (e.g., the, a, an) when they
appear as the first word in the title.

 
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
Sort order : Excel vs imported data John Excel Discussion (Misc queries) 0 December 9th 05 01:40 PM
How can I ignore articles in a sort using Excel or Word? Nothappy Excel Discussion (Misc queries) 2 December 2nd 05 04:23 AM
Import text to Excel Fredrik E. Nilsen Excel Discussion (Misc queries) 2 November 21st 05 06:55 PM
Is there a way to sort text by frequency within Excel? jellis1919 Excel Discussion (Misc queries) 1 August 12th 05 01:40 AM
Can you sort text in a random order in Excel tbowden Excel Discussion (Misc queries) 3 February 1st 05 02:42 PM


All times are GMT +1. The time now is 08:06 AM.

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

About Us

"It's about Microsoft Excel"