Changing text order

  • Thread starter Thread starter quinner
  • Start date Start date
Q

quinner

Hope someone can help.

How can I change this: (Lastname, firstname) all in the same cell
to: (Firstname Lastname) all in the same cell?
I need to invert the order of the names and eliminate the comma. I
think there is a function that will help me but I cannot find it.
Please help. Thanks.
 
Use Data > Text to Columns... with the comma as the separator to convert the
cell into two cells Last name in A1 and first name in B1. Then reverse the
order with

=B1 & " " & A1
 
You can use something like this: (with your data in A1)

=RIGHT(A1,SEARCH(" ",A1)-1)&" "&LEFT(A1,SEARCH(",",A1)-1)
 
Back
Top