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
|