How do I change a column in Excel with Last Name, First Name into a column with First Name Last Name-CodePudding

Hello how do I turn a whole column with cells like

Column 1

Ajrouche, Bob  
Apple, Jason A  
Richard Jr, Donald G

into

Column 2

Bob Ajrouche  
Jason A Apple  
Donald G Richard Jr

Thank you.

CodePudding user response：

You may try this in Excel,

• Formula used in cell C1

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

And If you are using O365, and currently in Insiders Beta Channel, then

• Formula used in cell B1

=TEXTAFTER(A1&" ",", ")&TEXTBEFORE(A1,", ")

CodePudding user response：

Select your column and then navigate to the Data tab and click "text to columns". A wizard will open and in the second step, make sure the delimiters are set to commas.

Now You have two columns: Column A = Last name & Column B = first name. In the first cell in column C type the formula =CONCAT(B1, A1). Select the cell and double click the autofill handle. And voila you have your first name last name column