In this Article, we will discuss about another set of useful Text Functions Microsoft Excel provides to search the text in the given text.
The EXACT formula
This function is used to compare two given text values and returns TRUE if both the values are match. The comparison is case-sensitive. That means, “Apple” and “apple” are two different strings.
The Syntax of the function is:
=TEXT(text1, text2)
Where text1 and text2 are the given strings. These two arguments are mandatory.
| Formula | Result |
| =EXACT(“Excel”, “Excel”) | TRUE |
| =EXACT(“Python”, “python”) | FALSE |
The FIND formula
To find a text in a given text, we can use FIND function in Microsoft Excel. Remember that this function also treats the data as case-sensitive.
The Syntax of the function is:
=FIND(find_text, given_text)
Where find_text is the text to be find in the given_text. If it finds the text, it returns the index value where it finds the text. Otherwise, it returns #VALUE! Error. Here are the examples:
| Formula | Result |
| =FIND(“Excel”, “Microsoft Excel“) | 11 |
| =FIND(“ex”, “Excel”) | #VALUE! |
Another variation of this function exists to start the search from the given index value.
The Syntax of the another version is:
=FIND(find_text, given_text, start_index)
Where start_index is the string index value from where to start the search in the given_text. This is useful to pick the particular instance of the text in the given text. Here are the examples:
| Formula | Result |
| =FIND(“text”, “Find text in a given text”, 6) | 6 |
| =FIND(“text”, “Find text in a given text“, 7) | 22 |
The FINDB formula
FINDB formula works similar to FIND formula; except it intended to works with Double Byte Character Set (DBCS). If DBCS language is NOT the default language, this functions works similar to FIND function.
We will discuss more topic in upcoming Articles.
🙂 Sahida