When processing large batches of data, few Excel functions are as versatile as the SUBSTITUTE function. Unfortunately, it is tragically often overlooked in favor of far more complicated solutions to what are often simple problems.
from MakeUseOf https://ift.tt/ohFq9bs
via IFTTT
