I'm trying to sort a list in Excel and one of the columns is a list of
titles. When I sort I want it to ignore the words "The" and "A" at the
beginning. (for example, I want "The Piano" to be with the Ps not the Ts).
I'm about to throw my computer across the room because I can't figure it out
and can't find anything in the Help sections that gives me the right answer.
I'm not the most savvy with Excel, but this really shouldn't be that hard.
Help me.
Bookmarks