in a "helper" column (say B):

in B1:

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

Copy down

Copy/Paste Special to get values (remove formula)

"hellison" wrote:

I am trying to change the data in a column from last name first to first name
first.

Example Doe, John to John Doe

Thanks