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
Sur cette page du site, vous pouvez voir la vidéo en ligne Replace text using the SUBSTITUTE function explained with examples in Excel and Google Sheets durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur WHIZBUSTERS 20 mars 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 280 fois et il a aimé 1 téléspectateurs. Bon visionnage!
