SUBSTITUTE in excel with a formula

SUBSTITUTE in excel with a formula

Have you ever received a worksheet where for example the dates were in a weird format?Not corresponding to anything that can remotely recognised by an excel system, on this side of the moon? 🙂 I certainly did. SUBSTITUTE is a very handy formula in many situations. I...