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: https://www.modernschoolbus.com/extract-numbers-or-text-from-string-google-sheets/ 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