Formulas > =FINDB()
How to Use FINDB() in Google Sheets
Description
How To Actually Use FINDB() in Sheets
FINDB(search_for, text_to_search, [starting_at])
Try FINDB yourself
In cells A1:A10, enter various text strings. Use the FINDB formula in cell B1 to find the position of the substring 'ab' in the text from A1. Drag the formula down to B10 to apply it to the other cells.
Hints (2)
-
Remember to reference the correct cell in your formula.
-
Make sure to drag the formula down to apply it to other cells.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the FINDB() formula:
Generate a FINDB() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses FINDB(). 2 free AI generations, no signup. Members get unlimited use.
Generate a FINDB() formula