Re: Separate TEXT
From: Dave R. (daverx_at_hotmail.com)
Date: 05/17/04
- Next message: Domenic: "Re: How to sum values in between"
- Previous message: DAA: "Re: Separate TEXT"
- In reply to: DAA: "Re: Separate TEXT"
- Next in thread: Domenic: "Re: Separate TEXT"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 15:42:25 -0700
I typed "John A. Doe" into A1, then used the formulas provided in the post
in B1, C1, and changed the D1 formula and it worked fine.
Good day.
"DAA" <anonymous@discussions.microsoft.com> wrote in message
news:e4cc01c43c5d$8c71a660$a601280a@phx.gbl...
> Sorry it didn't work. It shows "n D. Doe"
>
> >-----Original Message-----
> >Yipes, sorry.
> >
> >=RIGHT(A1, LEN(A1)-SUMPRODUCT(LEN(B1:C1))-3)
> >
> >
> >
> >
> >"Dave R." <daverx@hotmail.com> wrote in message
> >news:%233yiTtFPEHA.1276@TK2MSFTNGP11.phx.gbl...
> >> You mean instead of Doe? Try that;
> >>
> >> =RIGHT(A1,LEN(B1)+LEN(C1)+1)
> >>
> >>
> >> "DAA" <anonymous@discussions.microsoft.com> wrote in
> message
> >> news:e4ce01c43c58$bb98d300$a101280a@phx.gbl...
> >> > B1 and C1 works but D1 only shows "oe" (instead of
> Joe).
> >> > Thanks again.
> >> >
> >> >
> >> > >-----Original Message-----
> >> > >Assuming that the name will always have the same
> format
> >> > >
> >> > >FirstName MiddleInitial. LastName
> >> > >
> >> > >Formula Solution:
> >> > >
> >> > >In B1 enter =LEFT(A1,FIND(" ",A1,1)-1)
> >> > >In C1 enter =MID(A1,FIND(".",A1)-1,1)
> >> > >In D1 enter =RIGHT(A1,LEN(B1)+LEN(C1)+2)
> >> > >
> >> > >Copy these formulas down for as far as you have data
> in
> >> > >column A.
> >> > >
> >> > >tod
> >> > >
> >> > >>-----Original Message-----
> >> > >>Is there a way to separate text.
> >> > >>
> >> > >>A1= John A. Doe
> >> > >>
> >> > >>I would like to separate the text on A1 that would
> show:
> >> > >>
> >> > >>B1= John
> >> > >>C1= A (without the period)
> >> > >>D1= Doe
> >> > >>
> >> > >>Help and thanks in advance.
> >> > >>
> >> > >>.
> >> > >>
> >> > >.
> >> > >
> >>
> >>
> >
> >
> >.
> >
- Next message: Domenic: "Re: How to sum values in between"
- Previous message: DAA: "Re: Separate TEXT"
- In reply to: DAA: "Re: Separate TEXT"
- Next in thread: Domenic: "Re: Separate TEXT"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
