Previous Topic Next Topic

Excel-extracting names into seperate elements

Closed
GoldBar - Feb 2, 2011 at 03:12 PM
 Steveinuk - Feb 3, 2011 at 03:35 AM
Hello,

I have several hundred names in an excel file written like this Doe, John A and I want to seperate them into 2 columns with first names in one column and last names in another. Is there a way to extract the first word from each cell (their last name) into a cell? Or even better, can I get them separated and put into 2 seperate cells?

Thank you in advance!

Related:

1 response

Answer 1 / 1
Steveinuk
Feb 3, 2011 at 03:35 AM
=LEFT(F11,FIND(",",F11,1))
=RIGHT(F11,LEN(F11)-(FIND(",",F11,1)+1))

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses