Move name around

[Peter1973]

I am trying to get a formula to switch a name around ie i have Bloggs, Joe and need it to be switched to Joe, Bloggs. Hope this makes sense any help appreciated.

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).

There are some really cool new functions in Excel 365 that make this much easier. So it would be helpful to what version of Excel you are using.

 

[Joe4]

In Excel 365 it could look like this (for an entry in cell A1):

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

 

[Joe4]

In older versions of Excel, you could use:

=MID(A1,FIND(", ",A1)+2,99) & ", " & LEFT(A1,FIND(", ",A1)-1)