Replace text using the SUBSTITUTE function explained with examples in Excel and Google Sheets
🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟
https://whizbusters.teachable.com/p/e...
💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime
***************************************************************************************************** Use SUBSTITUTE function to find and replace text in your data based on content. Included are 4 examples on how to use the function and 3 tips about this function.
Included is also a comparison between Google Sheets and Excel regarding the #SUBSTITUTE function.
Time Stamps
00:00:00 Objective
00:00:09 What does the SUBSTITUTE Function do? (Purpose)
00:00:16 What does the SUBSTITUTE Function return? (Output)
00:00:27 Parameters in the SUBSTITUTE Function
00:00:57 Google Sheets versus Excel
00:01:17 Examples using the SUBSTITUTE Function
00:05:47 Tips and important notes when using the SUBSTITUTE function including default, optional values and case sensitivity
INDEX function: • EXTRACT values and arrays from a tabl...
MATCH function: • MATCH Function explained with example...
VLOOKUP function: • Master VLOOKUP explained with example...
FUNCTIONS: • Playlist
PROBLEMS: • Playlist
ORGANIZE DATE: • Playlist
SUBSTITUTE Function Support Docs: https://support.google.com/docs/answe...
Let’s connect on social:
Instagram: /
LinkedIn: / whizbusters
Twitter: / whizbusters
Facebook: / whizbusters
www.whizbusters.com
#GoogleSheets #MsExcel #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning
