| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula help needed-How to separate last and first names?
Wow!!! That was easy:))
Thank you so much Bob! Jan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
