I have a column of cells that have the last name first then the first name. Example:

C1
Smith John

Is there a formula/macro that can switch them all?