Sorting and the word The

[Dave]

Hiya

Does anyone know a way of sorting a list (of CD's or films) where the word
The wouldn't be included, so The Beatles would be under B, not T ?

I don't want to have to delete all the The's, so it will still say The
Beatles ?

TIA
Dave

 

[Chip Pearson]

Dave,

In a new column, enter the formula

=IF(LEFT(A1,4) = "the ",MID(A1,5,LEN(A1))&", The",A1)

and fill down as far as you need to go. Sort on this column instead of the
primary column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com