replace question
You rock Toppers!! Thanks!!!
"Toppers" wrote:
Try:
=SUBSTITUTE(SUBSTITUTE(B1,"*",A1,1),"*","")
This allows for a variable number of asterisks in Column B entries.
HTH
"Mike" wrote:
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
|