Excel formula help needed-How to separate last and first names?

J

Jan

Hello.
Here is my problem. I have the last and first name in the same column
and I need to have them separately in two separate columns in order to
be able to import into my contact management software.
Can someone please help me with that?
Thank you so much for your time and help.
Jan
 
B

Bob Phillips

Menu Data>Text To Columns and use space as a delimiter

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top