In this lesson, We are going to explore:
0:00 Getting started.
0:20 The Match case and entire cell contents features.
All explanations are simple and to the point.
#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you’re not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor):
https://www.benlcollins.com/

Google Sheets training:
https://support.google.com/a/users/answer/9282959

Worldometer | Countries in the World:
https://www.worldometers.info/geography/how-many-countries-are-there-in-the-world/

The whole playlist link:
https://youtube.com/playlist?list=PLyZklaIlJ-rdxhsA_Qv8pL5QQSiPAL_qC

Follow us on Pinterest:
https://www.pinterest.it/GoogleWorkspaceTutorial/_created/

Sound from Zapsplat.com
Apple logo
https://iconscout.com/contributors/pixel-icons

Windows logo
https://pixabay.com/it/users/

Welcome back, educators.
Our mission is to find and replace an exact word.
Finding the words that start with a lowercase using the REGEX.
And finally, find a formula and replace it with another one.
In this exercise, we are going to explore the Match case and Match entire cell contents features.
Open the search bar using the keyboard shortcut.
Type the word that you are looking for.
In this table, we find 2 cells that contain this word.
We’ll use the filter to confirm.
Double-checking is always recommended.
Open Find and replace window.
Select This sheet.
Type the word that you are looking for. and what you want to replace it with.
Click Replace all.
But that doesn’t what we want to achieve.
To replace the exact word that we’ve typed, activate these checkboxes.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.