ExcelBanter - rearrange text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - rearrange text (https://www.excelbanter.com/excel-worksheet-functions/86633-rearrange-text.html)

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