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

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

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

Menu DataText To Columns and use space as a delimiter

--

HTH

Bob Phillips

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

"Jan" wrote in message
oups.com...
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

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

Wow!!! That was easy:))
Thank you so much Bob!
Jan