Hello,
I have 2 columns; 'First Name' & 'Middle Name'
I have a 3rd column with this formula which extracts the first letter of the above 2 columns.
SUBSTITUTE(REGEX_REPLACE(({First Name}&{Middle Name}), "[a-z]", ""), " ", "")
Example: Jon Reginald Mayo = JRM
However, I want to add a space in between each character, any ideas on how to do this?