Is there a formula that will go through a column with mixed names and rearrange the ones that contain the format last name, first name and leave the first name last names alone?
Original Result
Smith, John John Smith
Terry Bradshaw Terry Bradshaw
Carter, Gary Gary Carter
Original Result
Smith, John John Smith
Terry Bradshaw Terry Bradshaw
Carter, Gary Gary Carter