D
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
John A. Is there a way ro re-arrange the names to John A.
Doe?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
Assuming that there is no coma after Doe.
With Doe in F2 and John A. in G2
HTH
Gilles Desjardins
D
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
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
D
Danny
Thanks guys. Both worked!
Danny
Danny
message news:[email protected]...-----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