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