Excel Functions Tutorials
- TEXT Functions in Excel
- Char Function In Excel
- CLEAN Excel Function
- CODE Excel Function
- Concatenate Excel Function
- CONCATENATE Formula in Excel
- Concatenate Date in Excel
- Concatenate Excel Columns
- Concatenate Strings in Excel
- Opposite of Concatenate in Excel
- EXACT Excel Function
- FIND Function in Excel
- LEFT Function in Excel
- LEN in Excel
- MID in Excel
- MID Formula in Excel
- PROPER in Excel
- Proper Formula in Excel
- REPT Function in Excel
- RIGHT Function in Excel
- Right Formula in Excel
- Search Function in Excel
- Substitute Function in Excel
- Substring in Excel
- TEXT Function in Excel
- TEXT Formula in Excel
- Trim in Excel
- Trim Formula in Excel
- VALUE Function in Excel
- Value Formula in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
Excel EXACT Function (Table of Contents)
EXACT Function in Excel
EXACT function is categorized as Text function in excel. The EXACT function in Excel is used to compare two text strings or values are exactly the same or not if so, returns TRUE else returns FALSE. The Excel Exact function is case-sensitive.
The EXACT in Excel returns TRUE if the two strings/values are the same in the supplied cells and returns FALSE if the two strings are different.
EXACT Formula Excel
Below is the EXACT Formula in Excel.
The EXACT formula excel has two compulsory parameters i.e. text1, text2.
- text1: It is the first string which we wish to compare.
- text2: It is the second text string.
How to Use the EXACT Function in Excel?
EXACT function in Excel is very simple and easy to use. Let understand the working of Excel EXACT function by some examples. The EXACT function in Excel can be used as worksheet function and as VBA function.
EXACT Function as Worksheet Function.
EXACT in Excel Example #1
In the first example, we compare the two string s in column text 1 and text 2 and apply the Exact formula excel in the output column as shown in the function column and the output will be as shown in the below table. The EXACT in Excel returns the TRUE where the text 1 and text are the same and FALSE where the text 1 and text2 values are not exactly the same.
EXACT in Excel Example #2
Suppose we wish that users of our worksheet enter data in the PROPER case in the Proper text-only column. So we can achieve it by using a custom formula based on the EXACT formula Exceland other functions.
Let’s consider the below table and you have to apply the restriction in the Proper text the only column in the below table.
First, select the C18 cell then click on data validation under the Data tab and select Data Validation. Change the validation criteria to custom and input the EXACT formula Excel =AND(EXACT(D18,PROPER(D18)),ISTEXT(D18)).
That’s it, now if you type a NONproper word in the Proper text-only column it will show you an error message like as follows:
EXACT in Excel Example #3
The EXACT in Excel is very useful when you have case-sensitive data.
In this example, we take a set of products where the case-sensitive products are available in the list.
As shown above, there are four products soft toys two being in lowercase and other in uppercase Heres we are looking out for numeric values, SUMPRODUCT + EXACT is an exciting and flexible way to do a case-sensitive lookup. We can use the EXACT formula Excel to be used is
The output is: 300
The EXACT in Excel can be used as a VBA function.
In VBA we can compare two string using strcomp function here is the example as follows:
Dim Lresult as string // declare the lresult as string
Lresult = StrComp (“Tanuj”, “tanuj”)
MsgBox(Lresult) //Output will show in MsgBox
Output will be 0 as String Tanuj and tanuj are not exactly matched.
Things to Remember About the EXACT Function in Excel
- Excel Exact function is used to compare two strings, you can also use the equal sign in a formula (text1=text2) to compare text strings. However, the equal sign is not case sensitive.
This has been a guide to EXACT Function in Excel. Here we discuss the EXACT Formula excel and how to use EXACT function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –