I'm importing data from an external database.
It imports NAME as either a company name or personal name.
Company name shows as:
ABC Company LTD.
Which is great!
But when it imports a personal name, it's formated into one cell as:
PULLEN/MICHAEL
How can I automate it so I can rearrange the cell to show:
MICHAEL PULLEN
Any help is much appricated...
It imports NAME as either a company name or personal name.
Company name shows as:
ABC Company LTD.
Which is great!
But when it imports a personal name, it's formated into one cell as:
PULLEN/MICHAEL
How can I automate it so I can rearrange the cell to show:
MICHAEL PULLEN
Any help is much appricated...