Скачать или смотреть Excel RIGHT and SUBSTITUTE Functions: With examples

Excel RIGHT and Excel SUBSTITUTE functions are very useful to get a substring from a text string. Unlike the Excel LEFT function, the Excel RIGHT function works from the Right. This tutorial is very detailed with a lot of examples in combining the RIGHT and SUBSTITUTE functions to get the best from the Excel SUBSTITUTE function. Link to the practice file for download is https://drive.google.com/uc?export=do...

Excel Excel RIGHT function - syntax explained
Use Excel RIGHT function in Excel - formula with examples
How to extract a substring before a certain character, like space, hyphen etc.
Remove the first few characters from a string with examples using the Excel SEARCH and Excel SUBSTITUTE function
Embed the Excel VALUE function with the Excel RIGHT function to return a number.
Nested Excel SUBSTITUTE
Replacing a character with another special character using Excel SUBSTITUTE function.
Replacing character with nothing using the Excel SUBSTITUTE function.

Are you a new subscriber? See link to all beginner videos https://www.youtube.com/@dataanalysis... MS Excel made easy. The link to the SEARCH and FIND video is    • How to use Excel FIND and SEARCH functions...  
Do you know how to create interactive dashboards in MS Excel? Watch it here    • How to create Dynamic Dashboards with MS E...  
How to extract the year, month, and day from a date string, watch this video    • How to use Excel WEEKNUM and other Excel D...  
I can be reached for customised MS Excel classes on the following platforms
Twitter:   / veronicabrendan  
Facebook:   / veronica.brendan  
LinkedIn:   / veronica-edeminam-165717a6  
Email: [email protected]

#msexcel #msexcelforbeginners