Switch First and Last Names

[Karen]

What is the excel formula to change John Brown to Brown, John? Thanks!

 

[Mike H]

Karen,

Try this

=MID(A1&" "&A1, FIND(" ",A1)+1,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Eduardo]

Hi,
try

=TRIM(RIGHT(A1,FIND(" ",A1)-1))&" "&TRIM(LEFT(A1,FIND(" ",A1)-1))

 

[Teethless mama]

=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)