Rearrange Last name, First name >>> First Name/Last Name

Good morning,

I have a thousand entries of names. The problem is the list has their names last name then first name. I would like it to be First Name then Last name.

Example:

In the cell it will say Hood, Robin
I would like it to say Robin Hood

Any help is grateful-

Thank you,

Try this assuming they all follow the same pattern of LastName Comma Space FirstName

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

Perfect!! Thank you!

You're welcome.