EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources TEXT and String Functions in Excel Excel EXACT Function
Secondary Sidebar
Excel Functions
  • TEXT and String Functions in Excel
    • Excel CODE Function
    • Excel Find
    • TRIM Formula in Excel
    • Excel CHAR Function
    • LEFT Formula in Excel
    • Opposite of Concatenate in Excel
    • Concatenate Strings in Excel
    • Extract Numbers From String
    • VALUE Formula in Excel
    • Left TRIM in Excel
    • Substring Excel Function
    • SUBSTITUTE Function in Excel
    • Excel VALUE Function
    • Excel REPT Function
    • Excel TRIM Function
    • Excel CLEAN Function
    • Excel EXACT Function
    • PROPER Function in Excel
    • Excel LEFT Function
    • MID Function in Excel
    • LEN Function in Excel
    • CONCATENATE Function in Excel
    • SEARCH Function in Excel
    • RIGHT Function in Excel
    • FIND Function in Excel
    • TEXT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Online COURSE
  • Online Excel Data Analysis Training

Excel EXACT Function

By Pradeep SPradeep S

EXACT Function in Excel

EXACT Function in Excel (Table of Contents)

  • EXACT Function in Excel
  • EXACT Formula in Excel
  • How to Use EXACT Function in Excel?

EXACT Function in Excel

The EXACT function is an inbuilt function in excel that is categorized under the TEXT function. It is used as a worksheet & VBA function in excel. EXACT function in Excel is used as a part of a formula in a cell of a worksheet & also integrated with other excel functions (IF, SUMPRODUCT & various other formulas of excel). It is most commonly used to perform a case-sensitive lookup between two strings. Excel is very easy to use and simple functions with two arguments.

Definition

Checks whether two strings are exactly the same and return TRUE or FALSE. It means the EXACT function in Excel compares two strings between two cells and returns TRUE if both values are the same & similar. Otherwise, it will return FALSE if both the strings do not match.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

EXACT Formula in Excel

Below is the EXACT Formula in Excel:

EXACT Formula in Excel

Explanation of the EXACT Function in Excel

The EXACT formula in excel has two parameters, i.e. text1, text2.

  • Text1: It is the first text string that we want to compare.
  • Text2: It is the second string that we want to compare.

The arguments can be entered manually, or cell reference can be given. The exact function is case-sensitive. i.e. Capital letters are not equal to small letters. It will return a FALSE value if there is a Leading or trailing space in any text strings, small or capital letters in a text string, Extra space between alphabets in a text, or uppercase or lower-case text between two strings or text.

The equal sign in a formula of exact function can also be used, i.e. (text1=text2) to compare text strings. Instead of the EXACT function, the double equals (==) comparison operator is also used to Compare between two strings. For example, =X1==Y1 returns the same value as =EXACT(X1,Y1).

How to Use EXACT Function in Excel?

The EXACT function in Excel is very simple and easy to use. Let understand the working of EXACT function in Excel by some EXACT Formula example.

You can download this EXACT Function Excel Template here – EXACT Function Excel Template

Example #1 – Text Containing Uppercase Letters

Here in the below-mentioned example. Cell B9 & C9 contains text strings; with the help of the EXACT function, I need to check whether the two cells have the same data or not.

  • Let’s apply the exact function in cell “D9”. Select the cell “D9” where an EXACT function needs to be applied.

EXACT Example 1-1

  • Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “EXACT” in the search for a function box, and the EXACT function will appear in select a function box. Double click on an EXACT function.

EXACT function 1-2

  • A dialog box appears where arguments for the EXACT function need to be filled or entered, i.e. =EXACT(B9,C9). Here, I need to compare between B9 & C9 cell; hence it is entered in the function arguments of an exact function. Click ok once it is entered.

EXACT Example 1-3

  • An EXACT function returns a FALSE value because both the strings do not match with each other. Here ‘c’ and ‘C’ are different, i.e. ‘c’ is lower case in text1, whereas ‘C’ is uppercase in text2, (EXACT function is case-sensitive)

EXACT Example 1-4

  • In the below-mentioned example, the EXACT function returns a TRUE value, Because both values in the cell B10 & C10 are the same & similar. i.e. Both the cells contain a proper case text string.

EXACT Example 1-5

Example #2 – Text Containing Spaces

Here in the below-mentioned example. Cell B13 & C13 contains the text strings; with the help of the EXACT function, I need to check whether the two cells have the same data or not.

  • Let’s apply the exact function in cell “D13”. Select the cell “D13” where an EXACT function needs to be applied.

EXACT Example 2-1

  • Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “EXACT” in the search for a function box, and the EXACT function will appear in select a function box. Double click on an EXACT function.

EXACT function 2-2

  • A dialog box appears where arguments for the EXACT function need to be filled or entered, i.e. =EXACT(B13, C13). Here, I need to compare between B13 & C13 cell; hence it is entered in the function arguments of an exact function. Click ok once it is entered.

EXACT Example 2-3

  • An EXACT function returns a FALSE value because both the strings do not match with each other. ‘XY Z’ and‘XYZ’ are different, i.e. ‘XY Z’ contains space between letter Y & Z in text1, whereas ‘XYZ’ does not contain any extra space between letters in the text2 column.

EXACT Example 2-4

  • An EXACT function returns a FALSE value if any extra space between alphabets in text or even if there is a Leading or trailing space in any text strings. In the below-mentioned example, the EXACT function returns FALSE value because there is a leading space in the cell “B14”, before the word XYZ, you can observe two extra space.

EXACT Example 2-5

Example #3 – Ignoring Format Pattern

In the below-mentioned example, Cell B18 contains $99, where it is in dollar value as currency format & C18 contains the 99, in number or general format. With the help of the EXACT function, I need to check whether the two cells have the same data or not.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,639 ratings)
  • Let’s apply the exact function in cell “D18”. Select the cell “D18” where an EXACT function needs to be applied.

EXACT Example 3-1

  • Click the insert function button (fx) under the formula toolbar, a dialog box will appear, type the keyword “EXACT” in the search for a function box, and the EXACT function will appear in select a function box. Double click on an EXACT function.

EXACT function 3-2

  • A dialog box appears where arguments for the EXACT function need to be filled or entered, i.e. =EXACT(B18, C18). Here, I need to compare between B18 & C18 cell; hence it is entered in the function arguments of an exact function. Click ok once it is entered.

EXACT Example 3-3

  • An EXACT function returns TRUE value because both the cell contains the same value, i.e. 99. Here Exact function ignores the format pattern of cells.

EXACT Example 3-4

  • In the below-mentioned example, the EXACT function returns TRUE value because both the cell contains the same date value, i.e. Cell “B19” contains the date value (5/16/18) in number or general format whereas in cell “C19” date value is present in date format. Here Exact function ignores the format pattern of cells.

EXACT Example 3-5

Things to Remember

  • The EXACT function is case-sensitive. i.e. Capital letters are not equal to small letters.
  • The exact function in Excel returns the false value if there is a difference in case pattern between text string, i.e. sentence case, lowercase, uppercase, proper case & toggle case.
  • The exact function in Excel returns the false value if there is Leading or trailing space & Extra space between alphabets in the text between two text strings.
  • EXACT Function in Excel ignores the formatting difference between the two cells.

E.G. 0.08 = 8%

$99 = 99

Recommended Articles

This has been a guide to the EXACT function in Excel. Here we discuss the EXACT Formula in Excel and how to use the EXACT Function in Excel along with practical examples and downloadable excel templates. You can also go through our other suggested articles –

  1. EVEN Excel Function
  2. HLOOKUP in Excel
  3. Excel SEARCH Function
  4. PMT Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download EXACT Function Excel Template

EDUCBA

Download EXACT Function Excel Template

EDUCBA

डाउनलोड EXACT Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more