Help

Adding space between initials (created using Substitute & Regex Replace)

Topic Labels: Formulas
500 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DM115
5 - Automation Enthusiast
5 - Automation Enthusiast

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?
1 Reply 1
seferiannie
6 - Interface Innovator
6 - Interface Innovator
SUBSTITUTE(REGEX_REPLACE(({First Name}&{Middle Name}), "[a-z]", " "), " ", " ")