Separating names

Topic

New Reply

I have a spreadsheet from an outside organization. They have first and last name in the same field separated by comma. I know there is some way to extract the name and put in another column but I can not figure it out since each name is a different length.
Please help!

Thanks,
Deb

Reply | Quote

Replies

If your name is in A1 then you could put the following formulae in B1
=LEFT(A1,FIND(“,”,A1,1)-1)
and in C1 you could have
=RIGHT(A1,LEN(A1)-FIND(“,”,A1,1)-1)

Reply | Quote

If necessary, insert an empty column to the right of the column with names.
Select the column or cells with names.
Select Data | Text to Columns…
Specify Delimited and click Next.
Tick the check box for Comma as delimiter (and possibly that for Space), then click Finish.

Reply | Quote

Thanks Hans….

There are so many little features in all the MS products. How does someone find the time to learn them all??
It worked like a charm.

Deb

Reply | Quote