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