Hi all -

I am trying to embed a substitute formula within a concatenation... for example my cell contains the text:

google.com

And in one long formula string, I would like to end up with:

^www\.google\.com$|




I am trying to substitute "\." for ".", so that formula is =substitute(google.com,".","\.")

Then I was concatenating, so I did =concatenate("^www\.",CELL WITH SUBSTITUTE FORMULA,"$|").



How can I embed the two so I don't need two columns with formulas?