In this lesson, We are going to explore:
0:00 Getting started.
1:01 How to find a formula and replace it with another?
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

Welcome back to the third part of the Find and Replace lesson.
How to find a formula and replace it with another?
We need to keep in mind that the Find feature searches the visual content of the cell and not the actual one.
If we try to find the join formula.
Google Sheets find no entries matching join.
When we activate the checkbox, the actual content of the cell appears.
And when we press Find, we jump to the cell that has the JOIN formula.
By clicking the Show formulae on the View menu, we get the same result.
Our mission is to find the CONCATENATE formula and replace it with the JOIN.
In cell E2, we have the JOIN formula.
And the CONCATENATE formula in cell E3.
Both use to join data together.
Now, click find and replace on the edit menu.
Type the formula name, activate the check box, then click Find.
Copy the formula, then paste it.
Type the name of the other formula, then press Find.
Copy the formula, then paste it.
Change the cells references, then click Replace.
The visual content is still the same, but now we use another formula.
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.