How can I reverse text in a single cell?

[Guest]

If I have, as an example In cell A1 (Henry, Patrick) and I want it to print
on a label Patrick Henry, how can I do that?

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Jason, however I must be doing something wrong it did not do anything.
Larry

 

[Guest]

Jason I did get it to work. Not sure what I was doing wrong before. I do
need to know how to reduce the gap between the first and last name. When I
did it it puts quite a gap between the names.
Thanks Larry H

 

[Aamir Hashmi]

HI

Try this

'=MID(B11,FIND(" ",B11,1)+1,LEN(B11)) & " " & LEFT(B11,FIND(" ",B11))

Aami