SUBSTITUTE patterns?
Gary''s Student wrote:
SUBSTITUTE() doesn't use wildcards. If F20 contains:
abc*der then =SUBSTITUTE(F20,"*","") returns: abcder
Of course I knew that. I wrote: "Of course, that does not work as I
intended." I hope my inquiry does not end with GS's comments. My
question was __not__ "does SUBSTITUTE allow wildcards". My question
was: is there __any_way__ to substitute patterns? (Other than the
MID/FIND combination that McGimpsey uses.)
|