Excel RIGHT and SUBSTITUTE Functions: With examples #msexcel #msexcelforbeginners

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=download&id=1jOZKHuL9SF3BS2-oNMK9Fs2xNhhoj2EZ

- 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/@dataanalysiswithveronicabr3408/videos MS Excel made easy. The link to the SEARCH and FIND video is https://youtu.be/2g8Joal7Xbc
Do you know how to create interactive dashboards in MS Excel? Watch it here https://youtu.be/OjJqf9uwqco
How to extract the year, month, and day from a date string, watch this video https://youtu.be/gINoYBGye-s
I can be reached for customised MS Excel classes on the following platforms
Twitter: https://twitter.com/veronicabrendan
Facebook: https://web.facebook.com/veronica.brendan/
LinkedIn: https://www.linkedin.com/in/veronica-edeminam-165717a6/
Email: veronicabrendan1@gmail.com

#msexcel #msexcelforbeginners

Видео Excel RIGHT and SUBSTITUTE Functions: With examples #msexcel #msexcelforbeginners канала Data analysis with Dr Veronica