Can anyone please help me, with what formula can I extract the first letter of each word in a range of names?
So I have a range of First, Second and third names and I would like to extract the initials to a separate cell. Some have only one name and some have 2 or 3 names. EG:
Mzolisi William
Nothemba Princess
Keith Vernon Peter
Leigh
And I want to extract the First letters so that the result would be
MW
NP
KVP
L
Bookmarks