Thank you, Niek! I appreciate your help.

:-)

"Niek Otten" wrote:

Or, if the names are more complex, look here

http://www.cpearson.com/excel/FirstLast.htm

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Phil" wrote in message
ups.com...
HI Nancy

assuming the names are all in the same column, try using the Text to
Columns tool to split them. You may need to paste the results into the
respective columns afterwards, but it's a nifty way of doing it!

HTH

Phil