I have the name, John Smith, in column A. Is there a way to keep John
in column A, but move Smith to column B (without re-typing it, of
course.)

Thank you.