kznmrexcel
Board Regular
- Joined
- Jun 16, 2010
- Messages
- 86
- Office Version
- 2016
- Platform
- MacOS
Hi, everyone,
Is there a way to take a full name and convert it to a first name last initial without adding an additional column/step with "text to columns?"
I would like to convert from cell D2 , < John Doe > to cell F2 < John D. >
I appreciate any help with this.
Thanks,
Karen
Is there a way to take a full name and convert it to a first name last initial without adding an additional column/step with "text to columns?"
I would like to convert from cell D2 , < John Doe > to cell F2 < John D. >
I appreciate any help with this.
Thanks,
Karen