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/2UlTfvB
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/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
The Ultimate Excel Course & Advanced Excel Tricks Bundle ► https://bit.ly/2YibpiM
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео 3 Advanced Examples of the SUBSTITUTE Function in Excel канала Computergaga
Want to see more advanced tricks?
Check out our online course - https://bit.ly/2UlTfvB
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/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
The Ultimate Excel Course & Advanced Excel Tricks Bundle ► https://bit.ly/2YibpiM
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео 3 Advanced Examples of the SUBSTITUTE Function in Excel канала Computergaga
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel's Find and Replace (surprising features)](https://i.ytimg.com/vi/3naynygx_dU/default.jpg)
![MS Excel - Text Functions](https://i.ytimg.com/vi/4mwaiA4rL4o/default.jpg)
![Use the REPLACE and SUBSTITUTE Functions](https://i.ytimg.com/vi/RzC0Mjj7Y_s/default.jpg)
![](https://i.ytimg.com/vi/qXmi4OlhULc/default.jpg)
![How to Create a Dynamic Searchable Drop Down List in Excel](https://i.ytimg.com/vi/4wr-ns5vvpM/default.jpg)
![Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions](https://i.ytimg.com/vi/hKBHOCEvcbw/default.jpg)
![Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi](https://i.ytimg.com/vi/7bwLaf4cKgw/default.jpg)
![Top 10 Most Important Excel Formulas - Made Easy!](https://i.ytimg.com/vi/ShBTJrdioLo/default.jpg)
![Microsoft Excel 2016 - Using the SUBSTITUTE() Function](https://i.ytimg.com/vi/JndP8i34tqA/default.jpg)
![Excel IF Function with PARTIAL Text Match (IF with Wildcards)](https://i.ytimg.com/vi/b9WoDkPOTPs/default.jpg)
![SUBSTITUTE Formula in Excel](https://i.ytimg.com/vi/YvHrFS-sfiU/default.jpg)
![How to remove Characters from fields in Excel](https://i.ytimg.com/vi/xArqGS67Cvs/default.jpg)
![This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)](https://i.ytimg.com/vi/aSPtWo3IiOM/default.jpg)
![2 ಗಂಟೆಯಲ್ಲಿ ಪೂರ್ತಿ MS-Excel ಕಲಿಯಿರಿ | Learn MS-Excel in 2 Hours](https://i.ytimg.com/vi/rfESLI6Mmc8/default.jpg)
![FIND() vs SEARCH() Function in Excel](https://i.ytimg.com/vi/tep4wSgygVE/default.jpg)
![VLOOKUP Tutorial for Excel - Everything You Need To Know](https://i.ytimg.com/vi/d3BYVQ6xIE4/default.jpg)
![Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)](https://i.ytimg.com/vi/ontXHp9cwOQ/default.jpg)
![How to use Excel Index Match (the right way)](https://i.ytimg.com/vi/F264FpBDX28/default.jpg)
![Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs](https://i.ytimg.com/vi/GUClkvJ7Gag/default.jpg)
![How to Use Substitute Function in Excel (Hindi)](https://i.ytimg.com/vi/TFs6AWfysKY/default.jpg)