Find and Replace and Trim Whitespace in Google Sheets

Описание: Part 3.1 of the Google Sheets 101 Series!

In this video we will look at using the Menu Options Find/Replace and Trim Whitespaces. Although there are functions for this, using the menu is much quicker if you only need to clean the data one time!

00:00 Introduction
02:04 ISEMAIL Function
04:32 Find/Replace
09:52 Trim Whitespace
11:35 Conclusion
12:24 End Slides

--
Links:
Here are the resources for these videos! Feel free to follow along with the Spreadsheet below, review the Hotkey (keyboard shortcuts) I used in the videos, or pick the "darkmode" or regular Function List below!:

Spreadsheet:
https://docs.google.com/spreadsheets/...

Hotkeys Table:
https://docs.google.com/spreadsheets/...

"Darkmode" Function List Document:
https://docs.google.com/document/d/1j...

Function List Document:
https://docs.google.com/document/d/12...

—
Socials:
WEBSITE: https://matttechtidbits.github.io/mat...
REDDIT:   / matttechtidbits  
LINKEDIN https://www.linkedin.com/in/matthew-k...

Song: "Grit Groove" By Ambiosynthesis
   • Grid Groove