Changing text order

[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.

 

[Guest]

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

 

[Cutter]

You can use something like this: (with your data in A1)

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