I know how to use =RIGHT to separate the last name when there are only 1st
and last name. How do I separate the last name when there are 3 or more
words in the name? EX: Linda Jane Ellen Doe or Mrs. Linda Ellen Doe I have
a column of names for an address list but the entire name was keyed into each
cell in column A (Mr. & Mrs. John H. Doe). I want to separate the last name
so that I can sort the list of names in alphabetical order.