I have some Excel files that have names listed either as last name, first name or first name last name in a cell. How can I easily switch these around either using visual basic or a formula?
For example if cell A2 is Doe, John how can I make it John Doe?
Alternatively if I have A2 as John Doe how can I convert it to Doe, John?
I have a few very large spreadsheets that would need this done on column A for example.