# Google Sheets SEARCH Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/search-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 SEARCH function locates a substring within a text string and returns its position, or an error if not found. ``` SEARCH(search_for, text_to_search, [starting_at]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the SEARCH you need in plain EnglishGenerate Formula ## Parameters **`search_for`**:\ The text string that you want to find within the `text_to_search`. This can be a specific word, phrase, or character. **`text_to_search`**:\ The text string or cell reference in which you want to search for the `search_for` string. **`starting_at`**:\ (Optional) The position in the `text_to_search` from which to start the search. If omitted, the search begins at the start of the `text_to_search`. ## What is a SEARCH Function in Google Sheets? The *SEARCH* function in Google Sheets is a useful tool that allows you to find the position of a substring within a string. It returns the starting position of the first occurrence of the specified substring, making it easier to analyze and manipulate text data. Unlike other text functions, SEARCH is case-insensitive, meaning it does not differentiate between uppercase and lowercase letters. In simpler terms, SEARCH helps you locate specific text within a larger body of text, which can be particularly useful for data cleaning and extraction tasks. ## A Practical Example Imagine you have a list of customer feedback comments stored in a Google Sheets document: ### Feedback Table: | FeedbackID | Comment | | - | - | | 1 | Great service and friendly staff | | 2 | The product quality is excellent | | 3 | I had a bad experience | You want to identify which comments mention the word "great" so you can highlight positive feedback. ## SEARCH Formula To achieve this, you would use the SEARCH function as follows: ``` =SEARCH("great", B2) ``` In this formula: - `"great"` is the substring you are searching for. - `B2` is the cell containing the comment you want to search within. ## Result of the Formula When you apply the SEARCH formula to the Feedback Table, the output would look like this: | FeedbackID | Comment | Position | | - | - | - | | 1 | Great service and friendly staff | 1 | | 2 | The product quality is excellent | #VALUE! | | 3 | I had a bad experience | #VALUE! | In this case, the SEARCH function returns `1` for the first comment, indicating that "great" starts at the first position. For the other comments, it returns `#VALUE!` because the substring "great" is not found. ## Why Use SEARCH? SEARCH is beneficial because it simplifies the process of locating specific text within larger strings. It can be used in combination with other functions, such as IF or ISNUMBER, to create more complex formulas for data analysis. Additionally, its case-insensitive nature allows for more flexible searches. ## Key Takeaways: - **SEARCH**: A Google Sheets function that finds the position of a substring within a string. - **Case-Insensitive**: Does not differentiate between uppercase and lowercase letters. - **Error Handling**: Returns `#VALUE!` if the substring is not found, which can be handled with additional functions. - **Common Use Cases**: Ideal for text analysis, data cleaning, and extracting specific information from larger text entries. SEARCH is an essential function for anyone working with text data in Google Sheets, providing a powerful way to enhance data manipulation and analysis capabilities. Happy spreadsheeting! ## Example use case You have a list of product descriptions in Column A and want to find if a specific keyword exists in any description. Using the SEARCH formula, you can quickly identify rows containing the keyword, streamlining product analysis and inventory management. ## 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 Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-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) - [How To Unhide Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-rows-in-google-sheets) - [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-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.