I want to replace a text string (in many formulas) that contains fixed
initial and terminal strings to be replaced and an intermediate string that
needs to be left in place. For example I want to change:
VLOOKUP(<inter-string, 1, FALSE)
into
MATCH(<inter-string, 0)

How can I do this when the REPLACE command does not preserve the text
matching the wildcard * character?