Website banner for SpreadsheetClass.com

Learn to automate and grow your business with spreadsheets

  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting
  • Home
  • Google Sheets
    • Tutorial
    • Formulas
    • Tips
    • Formatting
    • Error Troubleshooting
  • Cheat Sheet
    • Free PDF Cheat Sheet
    • Ultimate Cheat Sheet spreadsheet
  • Templates
    • Microsoft Excel Templates
    • Google Sheets Templates
  • Dashboards
    • Full dashboards course
    • Basic dashboard tutorial
  • Youtube
  • About
    • About
    • Contact
    • Hire an expert
    • LinkedIn
  • Excel
    • All Excel Lessons
    • Excel Templates
    • Excel Formulas
    • Excel Tips
    • Excel Formatting
    • Excel Error Troubleshooting

How to extract text and numbers in Google Sheets

Written by Corey Bustos Updated on April 8, 2019 in

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

Related Posts:

  • All the ways to extract text or numbers from a…
  • Finding the least common multiple with the LCM…
  • Finding the greatest common divisor with the GCD…
  • How to rotate text (make text vertical + more) in…
  • Convert decimal to duration in Google Sheets (&…
  • 2 ways to format values as currency in Google Sheets
Tweet Share Pin It Print

Welcome to Spreadsheet Class!

Corey Bustos

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.

Read More
  • Contact
  • About
  • Hire an expert
  • Video course
  • Formula cheat sheet
  • YouTube lessons
Example image of Google Sheets cheat sheet for sidebar
Free Dashboards image for the footer

Dashboard video tutorial

  • Hire an expert
Connect with me on LinkedIn
Free Cheat Sheet image for the footer
Copyright © 2023 Silver Sky, LLC. Silver Sky, LLC is a limited liability company headquartered in Colorado, USA. — Designed by WPZOOM
Contact
 
Privacy Policy
 
Terms and Conditions