Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I've tried to search on this but couldn't find anything.
I have a long list of employees entered in the form of Last name<space>Initial(s)
Is there a formula that I could use to swap these entries to become Initial(s)<space>Last name?
Thanks for your suggestions.
Mel
I have a long list of employees entered in the form of Last name<space>Initial(s)
Is there a formula that I could use to swap these entries to become Initial(s)<space>Last name?
Thanks for your suggestions.
Mel