Sort Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of different titles, some with words like "the" at the front
and I cant figure out how or if its possible to sort the list alphabetically
with out Excel picking up those words as the primary word to sort by. Is it
possible to make excel ignore those words when sorting? And if so how?
Thanks!
 
To remove "The" as the first word in a helper column to be sorted
A2: 'The Cat and the Cradle
B2: =IF(LEFT(UPPER(A1),4) = "THE ",MID(A1,5,200),A1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to I sort titles alphabetically like in a library? 16
Sort by Every Other Row? 0
How to sort entire spreadsheet by one column sort 5
Sorting 1
I want to sort on titles but wish to ignore, but not delete, the . 1
Sort in Greek alphabetical order 2
How do I get Excel to ignore "a", "an", "the" when sorting? 1
Open File menu sort alphabetical. 6

Back
Top