Sorting
Nothing built into excel allows this.
You could use a formula in another column to ignore the first word (like The,
An, A, ...) and then sort by that helper column.
Tomk wrote:
Does Excel 2007 have a built in way to sort a list of names and ignore "The"
in the title?
--
Tomk
--
Dave Peterson
|