EXACT()

Syntax. EXACT(text1,text2)

Definition. This function checks whether two strings are exactly the same and returns the logical value TRUE or FALSE.

Arguments

  • text1 (required). The first string to be compared.

  • text2 (required). The second string to be compared.

Background. You can use the EXACT() function in an array expression to check whether a list contains certain strings. With EXACT(), you can also validate text entered into a form.

This function is case-sensitive but ignores formats.

Example. Assume that after you have entered a list of data, you want to examine the array to check whether it contains a specific character string. The list is entered in the cell range B23:B48, and cell D22 contains the search string. Enter the following formula ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.