Arrow left
Back to product guides
Google Sheets Formulas

LEFT Function in Google Sheets: Explained

In this article, you will learn how to use the LEFT function in Google Sheets.

How to Use the LEFT formula in Google Sheets

  1. Type “=LEFT” or go to “Insert” “Function” “TEXT”“LEFT”
  2. Select a text by cell reference or manual input for “string
  3. Define how many letters the formula pull out from the begging of the text string by entering value at “number_of_characters
How to insert the LEFT function in Google Sheets

The generic syntax is as follows:

=LEFT(string, [number_of_characters])

Look at the examples in the picture below. The top table shows how the LEFT function works and the second one shows how you can use the formula to clean up a data set.

How to use the LEFT function in Google Sheets with examples

As you can see at the upper table, you can pull out characters from a text, a number and a date. This function is beneficial especially when you have a list of items with a specific number of code or words with a specific number of letters, and you want to extract them as independent values..

How do you use the RIGHT function in Google Sheets?

You can use the RIGHT function in the similar way with the LEFT function. Learn how to use the RIGHT function in Google Sheets here.

How do you align left and right text in Google Docs?

Go to this page to learn how to align texts in Google Sheets.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711