Substitute function has got may practical applications while using excel. Let us see this with five practical examples.
00:00 - Substitute function's Syntax
01:00 - Substitute All
02:08 - Substitute Some
03:57 - Remove Line Breaks
04:07 - Count Line Breaks
06:06 - Count words in a cell
#substitutefunction #exceltricks #msexcel
...
https://www.youtube.com/watch?v=4GwQEzQUZwI