Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

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

Topic Labels: Formulas
280 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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