Display only surname

P

Pat

Example:

A1 = TH Ewing B1 = Ewing
A2 = G Turner B2 = Turner
A3 = CIW Eastwood B3 = Eastwood


Col A contains peoples names using initials
Col B contains a formula that will return only the surname

I have tried MID and RIGHT in the formula but none seems suitable, anyone
got a solution?

Thanks
Pat
 
P

Paul B

Pat, try this, =MID(A1,FIND(" ",A1)+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
C

CLR

You could use Data > TextToColumns > using "space" as the delimiter, and
either break the names out into two columns, or choose not to import the
initials and only preserve the last names in column A

Vaya con Dios,
Chuck, CABGx3
 
Top