Home » Howto & Style » 3 Advanced Examples of the SUBSTITUTE Function in Excel

3 Advanced Examples of the SUBSTITUTE Function in Excel

Written By Computergaga on Tuesday, Apr 17, 2018 | 04:03 PM

 
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

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.