Formatting name in a cell

[jalifid11]

I'm looking for a formula that will allow me to "flip" the name around.

I currently have a name in a cell that says:

Jones Tom

I'm looking for something that will let me "flip" it to read:

Tom Jones

Any suggestions?

Here's the trick, I have other names in the columns that will need to be flipped to. All varying in lengths of names due to being, of course, different people.

 

[Richard Schollar]

Hi

Here's one way:

Excel Workbook
	A	B
1	Jones Tom	Tom Jones
Sheet2

 

[jalifid11]

Sweet... Just the trick..