Excel Function : FIND – FINDB

Download now!

Excel Function : FIND – FINDB

Category

Text

Description

Finds one text value within another (case-sensitive)

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FIND-FINDB-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628

Syntax and Description of the FIND – FINDB Excel Function

, or find the first occurrence of a value in a data range or array. =FIND(find_text,within_text, [start_num]) =FINDB(find_text,within_text, [start_num]) =FIND(find_text,within_text, [start_num]) =FINDB(find_text,within_text, [start_num]) find_text required. The text string you want to find. Within_text required. The text string containing the text you want to find. Start_num optional. Specifies the character within within_text at which you want to start the search. The first character

About FIND – FINDB Excel Function

The FIND and FINDB functions search a string for a specified character or set of characters. The difference between the two functions is that FIND is case-sensitive, while FINDB is not. The syntax for the FIND function is as follows: FIND(find_text,within_text,start_num) The find_text argument is the text you want to find. The within_text argument is the text you want to search. The start_num argument is the character at which to start the search. The syntax for the FINDB function is as follows: FINDB(find_text,within_text,start_num) The