I have no idea how to do this one

I have a worksheet and in one of the columns I have a list of names like this First Name the < sign and then the Last Name. Example ( JIMMY D<PRICE ).

Is there a way to extract the last names from each cell in this column and place it in a new column so I will have a column with the first name and a column with the last name instead of one column with the whole name?

Thanks
Waynesworld

You could try

Data , Text to Columns , delimiter , other and insert the > symbol.This will leave first name and intital in Column and insert surname in next Colmn

or use a helper column and enter


Surname
=RIGHT(A1,LEN(A1)-FIND("<",A1,1))

First Name
=LEFT(A1,LEN(A1)-FIND("<",A1,1))

VBA Noob

Originally Posted by Waynesworld

I have a worksheet and in one of the columns I have a list of names like this First Name the < sign and then the Last Name. Example ( JIMMY D<PRICE ).

Is there a way to extract the last names from each cell in this column and place it in a new column so I will have a column with the first name and a column with the last name instead of one column with the whole name?

Thanks
Waynesworld

Hi Waynesworld,

If data is in A1, then in B1

=LEFT(A1,SEARCH("<",A1,1)-1)

then in C1

=MID(A1,SEARCH("<",A1,1)+1,10)

oldchippy

Thanks for the help. I really don't know how some of you know all of this. I am truly amazed.

Thanks
Waynesworld