T tutu11 New Member Mar 18, 2019 #1 Have a good day, Not sure if I am googling the right function. I have 1 one that name "Lastname, FirstName PRID 12345" Just wondering how I remove any text after the first name.
Have a good day, Not sure if I am googling the right function. I have 1 one that name "Lastname, FirstName PRID 12345" Just wondering how I remove any text after the first name.
B bosco_yip Excel Ninja Mar 18, 2019 #2 Maybe....................... 1] Data put in A2. 2] In B2, enter formula : =LEFT(A2,FIND(" ",A2,FIND(" ",A2)+1)-1) Regards Bosco
Maybe....................... 1] Data put in A2. 2] In B2, enter formula : =LEFT(A2,FIND(" ",A2,FIND(" ",A2)+1)-1) Regards Bosco
