Use Texts in Google Sheets like a Pro 🚀 Change Case, Find and Replace, Split, Extract, and more
6.6 هزار بار بازدید -
3 سال پیش
-
Watch this step-by-step tutorial by
Watch this step-by-step tutorial by Railsware Product Academy to master using texts in Google Sheets. In this video, you will learn how to:
✅ Easily change the capitalization
✅ Find and replace specific text values
✅ Spot and remove extra spaces
✅ Combine and split texts
✅ Use wildcards as placeholders for the text characters
📝To follow along, make your copy of our practice sheet: http://bit.ly/practice-texts
🔌We use Coupler.io to import data from other apps to Google Sheets (e.g. Pipedrive, Hubspot, CSV, and many more): http://bit.ly/coupler-rw-txts
Timestamps:
0:00 Why you’re not using Google Sheets to its full potential
0:20 Video contents overview
0:48 How to change capitalization in Google Sheets
0:59 Formula to apply Title Case
1:46 How to UPPERCASE or lowercase your text
2:46 How to remove unneeded spaces
4:03 Find and replace text values in Google Sheets
5:40 How to combine texts from multiple cells into one
8:06 Connect multiple values with a delimiter
9:30 How to split text in Gsheets
11:17 3 ways to extract a certain number of characters
We’d love to hear from you!🙋♀️💬 Share your cases of using texts in Google Sheets in the comments ⬇️ Make sure to subscribe and hit the bell button 🔔 to learn more Google Sheets tricks coming up soon!
Design and video production: Oleg Gorovoi, Vlad Shagov
Cases: Natalia Gorovaia
Speaker: Anastasiia Avramenko
#ChageTextCaseGoogleSheets #SplitTextInGoogleSheets #ExtractTextInGoogleSheets
✅ Easily change the capitalization
✅ Find and replace specific text values
✅ Spot and remove extra spaces
✅ Combine and split texts
✅ Use wildcards as placeholders for the text characters
📝To follow along, make your copy of our practice sheet: http://bit.ly/practice-texts
🔌We use Coupler.io to import data from other apps to Google Sheets (e.g. Pipedrive, Hubspot, CSV, and many more): http://bit.ly/coupler-rw-txts
Timestamps:
0:00 Why you’re not using Google Sheets to its full potential
0:20 Video contents overview
0:48 How to change capitalization in Google Sheets
0:59 Formula to apply Title Case
1:46 How to UPPERCASE or lowercase your text
2:46 How to remove unneeded spaces
4:03 Find and replace text values in Google Sheets
5:40 How to combine texts from multiple cells into one
8:06 Connect multiple values with a delimiter
9:30 How to split text in Gsheets
11:17 3 ways to extract a certain number of characters
We’d love to hear from you!🙋♀️💬 Share your cases of using texts in Google Sheets in the comments ⬇️ Make sure to subscribe and hit the bell button 🔔 to learn more Google Sheets tricks coming up soon!
Design and video production: Oleg Gorovoi, Vlad Shagov
Cases: Natalia Gorovaia
Speaker: Anastasiia Avramenko
#ChageTextCaseGoogleSheets #SplitTextInGoogleSheets #ExtractTextInGoogleSheets
3 سال پیش
در تاریخ 1400/03/25 منتشر شده
است.
6,662
بـار بازدید شده