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

+4

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?

+5

SUBSTITUTE(REGEX_REPLACE(({First Name}&{Middle Name}), "[a-z]", " "), " ", " ")

1 reply