Display only surname

From: "Pat" <glass_patrick@xxxxxxxxxxx>
Date: Thu, 23 Jun 2005 20:43:25 +0100

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

.

Follow-Ups:
- Re: Display only surname
  - From: CLR
- Re: Display only surname
  - From: Paul B

Prev by Date: Re: Extending a balance ***
Next by Date: Summary of Max Hourly entries
Previous by thread: Address from one work*** to another
Next by thread: Re: Display only surname
Index(es):
- Date
- Thread