replace question
=SUBSTITUTE(B1,REPT("*",LEN(B1)-LEN(SUBSTITUTE(B1,"*",""))),A1)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Mike" wrote in message
...
Hey guys!
I have 2 columns A and B. What I need to do is take what is in column A
and
replace a string of astricks in Column B. For example:
Column A Column B Result
ABC need****help needABChelp
DEF more****help moreDEFhelp
Any idea how to do this??
Thanks guys!
Mike
|