How to swap around First and Last Names in one column ?

Hi ,

Anybody who can help me ?
I have received an excel sheet with in the first column Last Name, First Name of people.
I want to compare these to data from another excel sheet that uses First Name, Last Name.
Can you tell me how to swap around the names ?
Any hint on how to compare the data between my two sheets after the swap ?
(I was thinking to pull them into Access with a linked query)

Thanks in advance,
Dbase Beginner

There are various ways to do this.

One way would be to seperate the last name and first name into seperate columns using Data>Text to Columns...

Or you could use formula, perhaps something like this:

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