Fast Tip Friday – Edit Bates Numbers Using Excel Substitute Formula

FTF-Edit-Bates-Numbers-Using-Excel-Substitute-Formula

This fast tip demonstrates how to use the SUBSTITUTE formula in Excel. NOTE: While I realize that we could simply replace JONES_ with JONES- in this example, I wanted to keep things simple and leave it up to your imagination to see how useful this formula could be one day in your future. 🙂   […]