rearrange text

J

JJ

I need to flip the names in several cells...is there a formula or trick to
avoid doing it manually? I have the names set up as (Thomas, John) but need
them all to look like (John Thomas).
 
R

Ron Coderre

I think it was "Daddylonglegs" that posted this approach:

With A1: Public, John Q.

B1: =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

If extra spaces may be a problem:
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1))

Either way returns John Q. Public

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top