Formulas > =SEARCH()
How to Use SEARCH() in Google Sheets
Description
How To Actually Use SEARCH() in Sheets
SEARCH(search_for, text_to_search, [starting_at])
Try SEARCH yourself
In cells B1:B10, use the SEARCH formula to find the position of the word 'apple' in the corresponding cells of A1:A10. The formula should return the position number where 'apple' is found or an error if not found.
Hints (3)
-
Remember to reference the correct cell in column A.
-
SEARCH is case-insensitive, so it will find 'apple' regardless of case.
-
Make sure to drag the formula down to fill B1:B10.
4 Better Sheets Tutorials
Tic Tac Toe In A Google Sheet
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.
AND()
COUNTA()
FILTER()
IF()
IFERROR()
+4 more
How to Make Hangman Game In Google Sheets
Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets?
Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()
COUNTA()
IF()
IFERROR()
JOIN()
LEN()
+1 more
Allow Multiple Selections is in Google Sheets Yay!
Now you can select multiple options in a dropdown. Hip Hip Hooray!
FILTER()
IFNA()
JOIN()
SEARCH()
SPLIT()
+1 more
How to Filter Multi-Select Dropdown Feature
Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!
FILTER()
SEARCH()
SUM()
Learn more about the SEARCH() formula:
Generate a SEARCH() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SEARCH(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SEARCH() formula