Names re sorted in Excel cells 2

[SteveAudus]

I have a list of a 1000 names in cells
like this example

A | B
John Smith |
Hayley Howard |
Joe Mickard |
Adam Sharp |

Unfortunatley it's full names in one cell
I need the surname first, is there
a easy way of getting just their surname,
say into cell B.


Steve Audus
Chaucer Community School
Sheffield
UK

 

[dsi]

Try using this formula:

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,1))

 

[pjm]

Hi Steve

Try putting this in column B:

=MID(A1,FIND(" ",A1)+1,9999)

It will give you the surname if you always have just one space between first and surname and there are no initials etc.

HTH

pjm

 

[AidanEnos]

sure there is )

Save your excel file in text format
then open excel
open the text file
tell it to import as a delimited file, space, treat multiple delimiters as 1
finsih

You'll have what you want with the first name in column a and the last name in column b

If you want more help just ask )