Prev: Excel macro deployment
Next: Highlight the cell/row if particular name comes..
From: Myk on 29 Apr 2010 15:48
I currently have a list of names all in one column of cells that are
formatted last name, first name (with a space after the comma). I need to
change to first name last name. There are several names with no space after
the comma in case that matters.

Is there an easy way to make this change?

Thanks,
MYK
From: Luke M on 29 Apr 2010 15:54
=TRIM(MID(A2,FIND(",",A2)+1,999))&" "&LEFT(A2,FIND(",",A2)-1)

This will handle both cases of having a space, or no space

--
Best Regards,

Luke M
"Myk" <Myk(a)discussions.microsoft.com> wrote in message
news:FD6400CB-ADE8-45B7-A452-8762DF07CA99(a)microsoft.com...
>I currently have a list of names all in one column of cells that are
> formatted last name, first name (with a space after the comma). I need to
> change to first name last name. There are several names with no space
> after
> the comma in case that matters.
>
> Is there an easy way to make this change?
>
> Thanks,
> MYK


From: Jim Thomlinson on 29 Apr 2010 16:09
Try a formula like this...

=TRIM(MID(A1, FIND(",", A1)+1, 256)) & " " & LEFT(A1, FIND(",", A1)-1)
--
HTH...

Jim Thomlinson


"Myk" wrote:

> I currently have a list of names all in one column of cells that are
> formatted last name, first name (with a space after the comma). I need to
> change to first name last name. There are several names with no space after
> the comma in case that matters.
>
> Is there an easy way to make this change?
>
> Thanks,
> MYK
 | 
Pages: 1
Prev: Excel macro deployment
Next: Highlight the cell/row if particular name comes..