back to front

[Matkalg]

Hi

I have various cells with the names back to front set like this:

Smith, Frank
Jones, Harry

but i want them to be like this

Frank Smith
Harry Jones

With no commas, 3000 odd names with some ok and some not but from the look of it all the ones with commas with the second name before them

 

[Smitty]

If I read you right, this may work:

Book2
	A	B	C	D
1	Smith,Frank	FrankSmith
2	Jones,Harry	HarryJones
3	ChrisSmith	ChrisSmith
4	BobJones	BobJones
Sheet1

Hope that helps,

Smitty

EDIT: That didn't come out too well; formula is-->

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

 

[Matkalg]

thank you

thanks, it worked