SheetFX
≡
<< Go back to all functions

FINDB

The FINDB function in Google Sheets is used to find the position at which a specific string is first found within another text. This function counts each double-character as 2.

Function Syntax and Parameters

Syntax: FINDB(search_for, text_to_search, [starting_at])

Parameters:

  • search_for: The string you want to find within the text.
  • text_to_search: The text to search within.
  • starting_at [Optional]: The position within the text to start the search. If omitted, the search starts from the beginning.

Step-by-Step Tutorial

  1. Using FINDB to find the position of a string in a text:

    • Example: =FINDB("world", "Hello world!")
    • Result: 7

  2. Using FINDB to find the position of a string in a text, starting from a specific position:

    • Example: =FINDB("world", "Hello world!", 8)
    • Result: 0 (as "world" is not found starting from position 8)

Use Cases and Scenarios

  1. Text Analysis: Find the position of specific words in a text.
  2. Data Cleaning: Identify the location of specific characters within a dataset.
  3. String Manipulation: Extract specific portions of a string by finding their positions.

Related Functions

  • FIND: Similar to FINDB, but treats double-characters as one.

Related Articles