Get first letter of each word in a single cell
Let's say I have my A1 cell with the name of a client (John Appleseed). I need a formula that prints JA.
I was using REGEX.EXTRACT with the expression [A-Z\s]+, but I can only get one occurence (J or A).
Keep in mind that A1 is not always filled only with 2 words, I could have John Appleseed S.L., John Chapman Appleseed...
Do any of you guys know a way of doing this?
Thanks,
Dani
MacBook Pro 15″, 14.2