Forum Discussion

Bob Weil's avatar
Bob Weil
Copper Contributor
Sep 22, 2018
Solved

Last Name, First name to First Name Last Name,

This is probably pretty basic, but I need to convert (CONCAT?) a column of names from (Last Name, First name) to (First Name Last Name,).  Thanks, in advance!
Formulas and Functions
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Sep 22, 2018

    Ex" A2 = BOND, JAMES
    use: =RIGHT(A2,LEN(A2)-FIND(", ",A2))&" "&LEFT(A2,FIND(", ",A2)-1)
    to get JAMES BOND
    place formula only beside cells with comma

     

    ex: BOND JAMES

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

     

    pls see attached file

Bob Weil's avatar
Bob Weil
Copper Contributor
Sep 22, 2018
PS I need to skip cells that have no commas.
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 22, 2018
pls place some samples of output you need in the file I sent.
thanks
  • Bob Weil's avatar
    Bob Weil
    Copper Contributor
    Sep 22, 2018

    Best response - so far - I'm hoping ;-)

Resources