Display only surname
 

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

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

"Pat" wrote in message
...
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

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


"Pat" wrote in message
...
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