# Google Sheets LEFT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/left-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The LEFT function extracts a specified number of characters from the beginning of a text string in Google Sheets. ``` LEFT(string, [number_of_characters]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the LEFT you need in plain EnglishGenerate Formula ## Parameters **`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: | ProductCode | | - | | ABC123 | | DEF456 | | GHI789 | 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: | ProductCode | Category | | - | - | | ABC123 | ABC | | DEF456 | DEF | | GHI789 | GHI | 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! ## Example use case You have a list of product codes in Column A, and you want to extract the first three characters to identify the product category. Using the LEFT formula, you can quickly create a new column that displays just the category code for easier sorting and analysis. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.