3 Advanced Examples of the SUBSTITUTE Function in Excel

In this video, we look at 3 advanced examples of the SUBSTITUTE function in Excel.

Want to see more advanced tricks?
Check out our online course - https://bit.ly/3CGCm3M

This brilliant Excel formula helps us to manipulate and evaluate text strings in Excel.

There are many reasons to love the SUBSTITUTE function. This video narrows it down to 3 advanced examples.

Here are the timings of the video.
00:00 - Introduction to the video
00:28 - Count how many words in a cell
05:14 - Convert decimal separator
09:13 - Return characters after last delimiter

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1