How to Extract Numbers or Text from a String in Google Sheets

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

[Chaotic_Edits]

Just what I was looking for to help with extracting a date Awesome video

[gonebalance]

So useful and educational. Also simply explained. Thank you very much!

[jimb]

I noticed you had 3 empty columns when you split right which would of wiped out any data that was existing in those cell if there was any. How to you stop split from doing this?

[andreadegyves]

Hello, can you help me, what can I do If I have several words in one cell that I need to extract and each one is limited by ~~? ie: The ~car~ is ~fast~ and ~red~, when I try the expresons it only gives me the first word on the cell