Re: Display only surname
- From: "CLR" <croberts@xxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 17:30:21 -0400
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" <glass_patrick@xxxxxxxxxxx> wrote in message
news:#zpBUvCeFHA.2688@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
.
- References:
- Display only surname
- From: Pat
- Display only surname
- Prev by Date: Parsing in Excel?
- Next by Date: RE: Address from one work*** to another
- Previous by thread: Re: Display only surname
- Next by thread: Summary of Max Hourly entries
- Index(es):
