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

Google Sheets- Extract N characters to the LEFT

Written by Corey Bustos Updated on April 8, 2019 in

An example of how to extract N characters on the left of a string in Google Sheet by using the LEFT function

Related Posts:

  • All the ways to extract text or numbers from a…
  • Attendance tracker templates for Microsoft Excel
  • Attendance tracker templates for Google Sheets
  • How to rotate text (make text vertical + more) in…
  • Fixing SUM function errors in Google Sheets (SUM not…
  • 5 ways to indent 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