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
Nesta página do site você pode assistir ao vídeo on-line Replace text using the SUBSTITUTE function explained with examples in Excel and Google Sheets duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário WHIZBUSTERS 20 Março 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 280 vezes e gostou 1 espectadores. Boa visualização!
