# Google Sheets SPLIT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/split-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 SPLIT function divides text into separate cells based on a specified delimiter, allowing for easier data manipulation and analysis. ``` SPLIT(text, delimiter, [split_by_each], [remove_empty_text]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the SPLIT you need in plain EnglishGenerate Formula ## Parameters **`text`**:\ The string or cell reference containing the text you want to split. **`delimiter`**:\ The character or characters that determine where the text should be split. **`split_by_each`**:\ (Optional) A boolean value that indicates whether to split by each character in the delimiter (TRUE) or to treat the entire delimiter as a single entity (FALSE). The default is TRUE. **`remove_empty_text`**:\ (Optional) A boolean value that specifies whether to remove empty text items from the result (TRUE) or to include them (FALSE). The default is TRUE. ## What is the SPLIT Function? The *SPLIT* function in Google Sheets is a useful tool that allows you to divide text strings into separate components based on a specified delimiter. This function is particularly helpful when you have data in a single cell that you want to break down into multiple cells for better analysis or organization. In simpler terms, SPLIT enables you to take a long string of text and separate it into smaller, more manageable pieces. ## A Practical Example Imagine you have a list of full names in a single column, and you want to separate the first names and last names into two different columns. ### Names Table: | Full Name | | - | | John Doe | | Jane Smith | | Alice Johnson | ## SPLIT Formula To achieve this, you would use the SPLIT function as follows: ``` =SPLIT(A2, " ") ``` In this formula: - `A2` is the cell containing the full name you want to split. - `" "` is the delimiter, which in this case is a space character that separates the first name from the last name. ## Result of the Formula When you apply the SPLIT formula to the Names Table, the output would look like this: | First Name | Last Name | | - | - | | John | Doe | | Jane | Smith | | Alice | Johnson | As you can see, the full names have been successfully split into first and last names. ## Why Use SPLIT? SPLIT is beneficial because it simplifies the process of organizing and analyzing data that is stored in a single cell. It eliminates the need for manual separation of text and allows for quick data manipulation. This function is especially useful when dealing with imported data or when you need to prepare data for further analysis. ## Key Takeaways: - **SPLIT**: A Google Sheets function that divides text strings into separate components based on a specified delimiter. - **Easy to Use**: Just specify the cell and the delimiter to separate the text. - **Data Organization**: Helps in organizing data for better readability and analysis. - **Common Use Cases**: Ideal for separating names, addresses, or any text strings that contain delimiters. SPLIT is an essential function for anyone working with text data in Google Sheets, providing a straightforward way to enhance data organization and analysis. Happy spreadsheeting! ## Example use case You have a list of email addresses in Column A, formatted as "name\@example.com". Use the SPLIT formula to separate names and domains into Columns B and C, allowing for easier analysis of user data and email domain trends without manual parsing. ## 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 Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) - [How To Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets) - [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets) - [How To Transpose Data In Google Sheets](https://betteranalyst.com/google-sheets/how-to-transpose-data-in-google-sheets) - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets) ## 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.