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 ***