Fast Tip Friday – 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. 🙂

Download Sample Files

Leave a Reply

Your email address will not be published.