I have thousands of names in a Player Name column, and I'm wanting to store within another column the initials.
For example the following names would convert to the names on the right:
John McCarthy Blackham > JM Blackham
Nathaniel Frampton Davis Thomson > NFD Thomson
Henry Jupp -> H Jupp
How could this be done, so I could run something like this?
Set PlayerNameInitials = getinitials()