I have a column of cells that all have a last name followed by a comma and
then a first name. I need to have the last name in one column and the first
name in another. Is there a formula that will take the value of everything
up to the comma and put it in another column regardless of the length of the
name.

Example:
Column A Column B Column C
Smith, Robert Smith Robert
Washington, George Washington George