Find And Replace Wildcard Excel, As you've discovered, SUBSTITUTE does not support wildcards.