Adjust Code - Switch Last Name and First Name

[Anthony G.]

Hello to All

I came across this piece of code that does a fine job of switching "LastName, FirstName" to "FirstName LastName" however, I can't figure out how to remove the comma...

Any suggestions?

Thanks...Anthony

Book1
	A	B	C	D
1	Name
2	Smith,John	JohnSmith,
Sheet1

 

[Richard Schollar]

Here's an alternative:

Excel Workbook
	A	B
1	Smith, John	John Smith
Sheet1

 

[VoG]

Or

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

 

[Anthony G.]

Perfect...Thank you both!!

Anthony