D Danny Nov 18, 2003 #1 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
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
G Gilles Desjardins Nov 18, 2003 #2 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
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
D Dan E Nov 18, 2003 #3 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, 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 Nov 18, 2003 #4 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 Click to expand... message news:[email protected]...
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 Click to expand... message news:[email protected]...
