How do I reverse name order from Last, First to First Last in excel spread sheet

How do I reverse name order from Last, First to First Last in excel
Can you walk me through exactly what to do? I copy and pasted the formula suggested in a previous play and pasted it in the cell I wanted to reverse the order and I received this error #VALUE!

can you give more information? where are the names stored, and where do you want to display them?
uploading a sample spreadsheet could help

OK, Here is what I'm working with Nicky. I do play-by-play for HS Football games and the roster the coach sent me is Last name, First name and I want to reverse it to First, Last. Can you help. I'm not to knowledgeable about macros or the advance formulas of Excel so I will need the instructions explained in a lot of detail if possible.

Hi
Jakobshavn's formula should work - just replace A1 with B2 and copy down the column

Do I just type it in over the names or what do i need to do? Told you I had no clue.

in a cell in an empty column, such as K2, copy this variation on Jakobshavn's formula:

=REPLACE(B2 & " " & LEFT(B2,FIND(",",A1)-1),1,FIND(",",B2)+1,"")

it will return "Andre Harton" if your sheet has "Harton, Andre" in cell B2

copy this formula down into as many rows as there are names to transpose - to cell K49 in this example

if you want to overwrite the values that are already in column B, copy the range with the formulas in (K2:k49), select cell B2 and select
paste special > paste value

(if you copy the formulas you will get an error - it must be the values)

Repeat the process for the names in column G, changing B2 to G2 in the formula for the first cell

This is all I get

#VALUE!

ok, YOU GUYS TOTALLY ROCK!!!!!!!!!!!

Thank for all the help

I hit the star but how do I mark it solved.