Fast Tip Friday – Edit Bates Numbers Using Excel Substitute Formula

Amy Bowser-Rollins · Intermediate ·📊 Data Analytics & Business Intelligence ·9y ago

About this lesson

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: http://litigationsupportguru.com/FTF-ExcelSubstituteFormula

Original Description

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: http://litigationsupportguru.com/FTF-ExcelSubstituteFormula

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Related Reads

Database Internals: 4 Things Every Developer Should Learn Before Writing More Code

Learn database internals to improve coding efficiency and scalability

Medium · Machine Learning

Ranking Numeric Values using Power Query(.pbix included)

Learn to rank numeric values in Power Query for data analysis and comparison

Medium · Data Science

The Data Foundation for Finance Transformation at Enterprise Scale

Learn how to build a canonical finance data repository for enterprise-scale finance transformation, enabling a single source of truth for over 1M daily transactions

Medium · Data Science

Your Pipeline Is 25.4h Behind: Catching Defence Sentiment Leads with Pulsebit

Learn to use Pulsebit's News Sentiment API to catch defence sentiment leads and optimize your pipeline with real-time sentiment analysis

Dev.to · Pulsebit News Sentiment API

This could be the most perfect data frontend