I have a list of names typed in Last, First format within a single column in Excel. Now someone is wanting to separate first and last name to use in mail merge. It would probably be best to break them out into individual columns. Can anyone help with this? Thanks in advance!
Example
Column A
Doe, John A.
Need:
Col. A Col. B
John A. Doe
Scott
Example
Column A
Doe, John A.
Need:
Col. A Col. B
John A. Doe
Scott