rearrange text

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

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


"JJ" wrote:

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