In this video, I show how to extract numbers or text from a string in Google Sheets. I show six different functions that can be used to parse your string and return the desired numbers or text. I cover these functions: LEFT, RIGHT, MID, SPLIT, REGEXEXTRACT, and REGEXREPLACE

Read through the full tutorial here:
[ Ссылка ]

Timestamps
00:00 Intro
00:23 LEFT function
1:47 RIGHT function
2:33 MID function
3:58 SPLIT function
7:11 REGEXEXTRACT function
9:56 REGEXREPLACE function
11:57 Extraction formula examples

свернуть