Arrange Text

[Danny]

I have hundreds of names in multiple columns, Ex: Doe,
John A. Is there a way ro re-arrange the names to John A.
Doe?

Thanks

 

[Gilles Desjardins]

Try the following =CONCATENATE(G2&" "& F2)
Assuming that there is no coma after Doe.
With Doe in F2 and John A. in G2

HTH

Gilles Desjardins

 

[Dan E]

Danny,

Give this formula a try...

=RIGHT(A1,LEN(A1) - SEARCH(" ",A1)) & " " & LEFT(A1,SEARCH(",",A1)-1)

The results will probably depend on whether or not all of your entries are like
the sample you provided. It worked for "Doe, John A." and "Doe, Jane"

Dan E

 

[Danny]

Thanks guys. Both worked!

Danny

-----Original Message-----
Danny,

Give this formula a try...

=RIGHT(A1,LEN(A1) - SEARCH(" ",A1)) & " " & LEFT(A1,SEARCH (",",A1)-1)

The results will probably depend on whether or not all of your entries are like
the sample you provided. It worked for "Doe, John A." and "Doe, Jane"

Dan E

"Danny" <[email protected]> wrote in

message news:[email protected]...