Google Sheets LEFT Function: Syntax, Examples & Tips

string:
The text string from which you want to extract the leftmost characters.

number_of_characters:
The number of characters you want to extract from the left side of the string. This parameter is optional; if omitted, it defaults to 1.

What is a LEFT Function?

The LEFT function in Google Sheets is a simple yet effective tool used to extract a specified number of characters from the beginning of a text string. This function is particularly useful when you need to isolate a portion of text for analysis or reporting purposes.

In simpler terms, the LEFT function allows you to pull out the first few characters from a string, making it easier to manipulate and analyze text data.

A Practical Example

Imagine you have a list of product codes in a Google Sheets document:

Product Codes Table:

You want to extract the first three characters from each product code to categorize them.

LEFT Formula

To achieve this, you would use the LEFT function as follows:

=LEFT(A2, 3)

In this formula:

• A2 is the cell containing the ProductCode from the Product Codes Table.
• 3 is the number of characters you want to extract from the left side of the string.

Result of the Formula

When you apply the LEFT formula to the Product Codes Table, the output would look like this:

In this case, the LEFT function extracts the first three characters from each product code, allowing you to categorize them easily.

Why Use LEFT?

The LEFT function is beneficial because it simplifies the process of text manipulation in Google Sheets. It allows you to quickly extract relevant portions of text without the need for complex formulas. This can be particularly useful in data cleaning, categorization, and reporting tasks.

Key Takeaways:

• LEFT: A straightforward function that extracts a specified number of characters from the beginning of a text string.
• Simplicity: Easy to use and understand, making it accessible for users of all skill levels.
• Common Use Cases: Ideal for data cleaning, categorization, and any scenario where you need to isolate specific portions of text.

The LEFT function is an essential tool for anyone working with text data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!