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
En esta página del sitio puede ver el video en línea Replace text using the SUBSTITUTE function explained with examples in Excel and Google Sheets de Duración hora minuto segunda en buena calidad , que subió el usuario WHIZBUSTERS 20 marzo 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 280 veces y le gustó 1 a los espectadores. Disfruta viendo!
