excel substitute function on all columns code example Example: excel replace character =SUBSTITUTE(text,old,new)