Excel Substitute and Replace

Maybe I knew this and had to relearn it, but was momentarily stumped when I needed to do some quick clean up and started to use the replace function. The syntax for it seemed strange:     Turns out what I needed was Substitute. Here’s what the help page says: Substitutes new_text for old_text in […]

Read more "Excel Substitute and Replace"