Formula Generator - FINDB function
The FINDB function is used to find the position at which a string is first found within text, counting each double-character as 2. It returns the position as a number. The optional 'starting_at' argument specifies the character position at which the search should start. If not provided, the search starts from the beginning of the text.How to generate an FINDB formula using AI.
To obtain the FINDB formula, you can ask the AI chatbot the following question: "What is the Excel formula used to find the position of a specific character within a text string?"
FINDB formula syntax.
The FINDB function in Excel is used to find the position of a specific character or text within a given text string. The syntax for the FINDB function is as follows: FINDB(find_text, within_text, [start_num]) - find_text: This is the text or character you want to find within the within_text. - within_text: This is the text string in which you want to search for the find_text. - start_num (optional): This is the starting position of the search within the within_text. If omitted, the search will start from the first character. The FINDB function returns the position of the first occurrence of the find_text within the within_text. If the find_text is not found, it returns the #VALUE! error. Note that the FINDB function is case-sensitive. If you want a case-insensitive search, you can use the FIND function instead.
Finding the position of a specific word in a text
In this use case, we use the FINDB function to find the position at which a specific word is first found within a given text. The function counts each double-character as 2.
FINDB("word", A1)
Extracting a substring after a specific character
In this use case, we use the FINDB function to find the position of a specific character within a text, and then extract the substring after that character.
MID(A1, FINDB("@", A1) + 1, LEN(A1) - FINDB("@", A1))
Checking if a text contains a specific pattern
In this use case, we use the FINDB function to check if a text contains a specific pattern. If the pattern is found, the function returns the position at which it is first found; otherwise, it returns an error value.