How to use the split function in Google Sheets (BONUS) ELIMINATING PUNCTUATION
Split function tutorial in Google Sheets #split #googlesheets. Learn how to split up your text in Google sheets. You will also learn to use the regexextract formula to eliminate punctuation #regex #regexextract #punctuation. The formula referenced in the video can be found and copied and pasted below (change our the A3 to your own use case):
=iferror(regexextract(A3,"[A-Za-z].*[A-Za-z]"),regexextract(A3,"[A-Za-z]"))
