Hi All,

I am trying to combine and organize a bunch of SL spreadsheets for a
charity. Some of the worksheets have first and last names. Some have
everything in one column which may include prefixes such as "Mr.", "Mr. and
Mrs.", "Dr. and Mrs." etc. Many of the entries don't have a prefix. I can
separate the words by using the text-to-column program but the first and last
names don't line up because of the prefixes.

I know outlook can break them up automatically but is there a way to do it
in Excel?

Thanks, sh