How to extract text and numbers in Google Sheets

How to extract text, numbers, and punctuation in Google Sheets by using a variety of formulas