Fast Tip Friday – Edit Bates Numbers Using Excel Substitute Formula
|

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…

Fast Tip Friday – Using Excel VLOOKUP to Compare Lists of Bates Numbers
|

Fast Tip Friday – Using Excel VLOOKUP to Compare Lists of Bates Numbers

This fast tip demonstrates how to use the VLOOKUP function in Excel to compare two lists of bates numbers and then a couple of ways to visually present the results. In a previous fast tip, I demonstrated an alternative way to use Excel to compare two lists. Download Sample Files

End of content

End of content