FINDB
The FINDB function returns the starting position of a specified substring within a text string. It is useful for locating specific text within a larger body of text.
Syntax 🔗
=FINDB(find_text, within_text, [start_num])
find_text | The text you want to find within another text string. |
within_text | The text string in which you want to search for the 'find_text'. |
start_num (Optional) | The character position within 'within_text' to start the search. Defaults to 1 if omitted. |
About FINDB 🔗
The FINDB function in Excel helps you find the position of a specific text within a larger text. To use it, provide the text you want to find ('find_text') and the text where you want to search ('within_text'). FINDB will return the position of the first occurrence of 'find_text' in 'within_text'. You can also use the optional 'start_num' argument to specify a starting character position for the search.
Examples 🔗
Let's consider you have the text string 'Hello World, this is Excel!' and you want to find the position of the word 'World'. If the cell containing the text is A1, you can use the formula: =FIND("World", A1)
Suppose you have the text 'Excel functions are super helpful!' and you want to find the position of the word 'super' starting from the 10th character. You can use the formula: =FIND("super", A1, 10)
Notes 🔗
The FINDB function is case-sensitive, so it distinguishes between uppercase and lowercase letters. If 'find_text' is not found within 'within_text', FINDB returns the #VALUE! error. Adjust your search parameters to fit your specific text search needs.
Questions 🔗
The main difference between FINDB and FIND lies in their treatment of text case. FINDB is case-sensitive, distinguishing between uppercase and lowercase characters, while the FIND function is case-insensitive and treats all text as the same regardless of case.
Can the FINDB function handle wildcard characters or patterns in the search text?No, the FINDB function does not support the use of wildcard characters or patterns in the search text. It looks for an exact match of the specified 'find_text' within the 'within_text' string.
How can I extract a specific portion of text using the FINDB function?To extract a specific portion of text using FINDB, you can combine it with other functions like MID or LEFT to extract the desired segment based on the position found by FINDB. For instance, you can use MID function in combination with FINDB to extract text after a specific word or character position.