Hi, I want to return the initials of a name.
ie Joe Bloggs, I want to have JB. Now, I can easily get the 1st initial; however, I am struggling to get the 1st character after a space.
Any help would be greatly appreciated.
Many thanks in advance
Hi, I want to return the initials of a name.
ie Joe Bloggs, I want to have JB. Now, I can easily get the 1st initial; however, I am struggling to get the 1st character after a space.
Any help would be greatly appreciated.
Many thanks in advance
Here, try this:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Absolutely perfect. Thank you so much.
I'm probably too late, but try this
Peter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks