parsing a column in MS Excel 2000

[Pccoordinator]

I have imported data that has last and first name in the same column. I want to parse out the last name from the rest of the data.

How can I do that in Excel 2000?

 

[DarkSun]

It depends how the names are seperated.

you need to use a combination of FIND,MID,LEFT,RIGHT depending on how the names are formatted.

What do the names look like?

 

[DarkSun]

Example 1:
A1 is "Smith,Mike"

to get Surname use:

=LEFT(A1,FIND(",",A1)-1)

Example 2:
A1 is "Smith Mike"

to get Surname use:

=LEFT(A1,FIND(" ",A1)-1)

Example 3:
A1 is Mike Smith

to get Surname use:

=MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1))