Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have a text string (an individual's name ... surname, given) in B16 eg. "Martin, Allan"
I am looking for a VBA solution to extract the individual's initials to be put in cell C16.
In this example ... C16 = "AM"
I know how to get the "M", but I am not sure how to isolate the first letter after the space.
I am looking for a VBA solution to extract the individual's initials to be put in cell C16.
In this example ... C16 = "AM"
I know how to get the "M", but I am not sure how to isolate the first letter after the space.