Actually made that formula more complicated than it needed to be.
Try this:
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Ron Coderre" wrote in message
...
With
A1: The Clown, Bozo

This formula converts that text to FirstName LastName
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1&" "&A1)+1,LEN(A1)))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Tina" wrote in message
...
I have imported data from another program and all of the names are in
this
format: Last Name, First Name

How can I change to First Name Last Name???