Right and Left Formula

Hello all,

I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
convert to FIRST NAME LAST NAME - No comma. I got pretty far with the
formula below.

This is what it looks like: Tackett, Raymond
This is what I want it to look like: Raymond Tackett
This is what the formula below makes it look like: RaymondTackett,

=(RIGHT(A2,LEN(A2)-FIND(" ",A2))) & (LEFT(A2,FIND(" ",A2,1)))

Thanks,

Raymond

Try...

=RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)

Hope this helps!

In article <834D638E-EAAF-4EC3-BB0D-E0B9D6F868D3@microsoft.com>,
"Raymond" <Raymond@discussions.microsoft.com> wrote:

> Hello all,
>
> I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
> convert to FIRST NAME LAST NAME - No comma. I got pretty far with the
> formula below.
>
> This is what it looks like: Tackett, Raymond
> This is what I want it to look like: Raymond Tackett
> This is what the formula below makes it look like: RaymondTackett,
>
> =(RIGHT(A2,LEN(A2)-FIND(" ",A2))) & (LEFT(A2,FIND(" ",A2,1)))
>
> Thanks,
>
> Raymond

This did make them in the correct format but it is skipping every other cell.
Awesome job though! It is changing A2, A4, A6, etc...

"Domenic" wrote:

> Try...
>
> =RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)
>
> Hope this helps!
>
> In article <834D638E-EAAF-4EC3-BB0D-E0B9D6F868D3@microsoft.com>,
> "Raymond" <Raymond@discussions.microsoft.com> wrote:
>
> > Hello all,
> >
> > I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
> > convert to FIRST NAME LAST NAME - No comma. I got pretty far with the
> > formula below.
> >
> > This is what it looks like: Tackett, Raymond
> > This is what I want it to look like: Raymond Tackett
> > This is what the formula below makes it look like: RaymondTackett,
> >
> > =(RIGHT(A2,LEN(A2)-FIND(" ",A2))) & (LEFT(A2,FIND(" ",A2,1)))
> >
> > Thanks,
> >
> > Raymond
>

NEVERMIND. For some reason when I used your formula, it merged and wrap text
on every other cell. I unmerged them and it works now. APPRECIATE IT!

"Domenic" wrote:

> Try...
>
> =RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)
>
> Hope this helps!
>
> In article <834D638E-EAAF-4EC3-BB0D-E0B9D6F868D3@microsoft.com>,
> "Raymond" <Raymond@discussions.microsoft.com> wrote:
>
> > Hello all,
> >
> > I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
> > convert to FIRST NAME LAST NAME - No comma. I got pretty far with the
> > formula below.
> >
> > This is what it looks like: Tackett, Raymond
> > This is what I want it to look like: Raymond Tackett
> > This is what the formula below makes it look like: RaymondTackett,
> >
> > =(RIGHT(A2,LEN(A2)-FIND(" ",A2))) & (LEFT(A2,FIND(" ",A2,1)))
> >
> > Thanks,
> >
> > Raymond
>

Domenic wrote...
>Try...
>
>=RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)

You could dispense with the unnecessary LEN call by using MID

=MID(A2,FIND(",",A2)+2,1024)&" "&LEFT(A2,FIND(",",A2)-1)

or REPLACE

=REPLACE(A2,1,FIND(",",A2)+1,"")&" "&LEFT(A2,FIND(",",A2)-1)

Thanks Harlan! Much appreciated!

In article <1117045905.713882.205040@g47g2000cwa.googlegroups.com>,
"Harlan Grove" <hrlngrv@aol.com> wrote:

> Domenic wrote...
> >Try...
> >
> >=RIGHT(A2,LEN(A2)-(FIND(",",A2)+1))&" "&LEFT(A2,FIND(",",A2)-1)
>
> You could dispense with the unnecessary LEN call by using MID
>
> =MID(A2,FIND(",",A2)+2,1024)&" "&LEFT(A2,FIND(",",A2)-1)
>
> or REPLACE
>
> =REPLACE(A2,1,FIND(",",A2)+1,"")&" "&LEFT(A2,FIND(",",A2)-1)