Cell text manipulation

[Joemaha]

If I have cells with input "FirstName,LastName" in the same cell, what is the best way to manipulate the text into a new cell with the input being "LastName,FirstName"? If possible, I would like to do this without using macros. Any ideas?

 

[bluedragon2]

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



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Joemaha]

Thanks Blue, got closer, but still not getting a usable output...
The formula worked on a few, but not that many.

Example
Jim,Wilson became Wilson,Jim,W

Any way to fix this??

Thanks in advance

 

[cLFlaVA]

Joemaha -

This worked for me:

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

*cLFlaVA
----------------------------
A polar bear walks into a bar and says, "Can I have a ... beer?"
The bartender asks, "What's with the big pause?

 

[KenWright]

Select the data, do Data / Text To Columns / Delimited / Tick the comma option, hit Next and Finish

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Joemaha]

Thanks everyone,
I took some advice off Bluedragon's post and used the Left and Right commands while modifying the use of Find with the commas. Kind of a roundabout compared to some other solutions, but It's working for me. Thanks alot.