Switch positions in column

[Novice]

Hi
I have an excel spreadsheet with peoples names forename,surname ina single column. The other spreadsheet has them surename,forename.
Is there a way to reverse all name in the first spread sheet so they match?
The names forname & surname are seperated by a , in a single column?
Thanks
Novice

 

[Cbrine]

Hi
I have an excel spreadsheet with peoples names forename,surname ina single column. The other spreadsheet has them surename,forename.
Is there a way to reverse all name in the first spread sheet so they match?
The names forname & surname are seperated by a , in a single column?
Thanks
Novice

This formula will reverse the firstname, Lastname to Lastname, FirstName

=MID(A1,FIND(",",A1)+1,30) &","&LEFT(A1,FIND(",",A1)-1)

If there are any extra comma's in the field, it will get messed up.

 

[amigos]

I am not sure how they are separated so try some of those:

Book1
	A	B	C	D
1	Stephen,Howe	Howe,Stephen
2	Stephen,Howe	Howe,Stephen
3	Stephen,Howe	Howe,Stephen
4	Stephen,Howe	Howe,Stephen
Sheet1

HTH