Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Two-column Lookup in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel VLOOKUP Function
  • Left Lookup in Excel
  • How to get last row in text data in Excel

Data Analysis Examples

  • Working With Tables in Excel
  • How to create a Histogram in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to Create Thermometer Chart in Excel
  • How to Use Solver Tool in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation date in specific year
  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation must begin with

How to compare two text strings in Excel

by

If you need to compare two text strings in Excel to determine if they’re equal, you can use the EXACT function.

Formula

=EXACT(text1, text2)

Explanation

For example, if you want to compare A2 with B2, use:

Worked Example:   How to Check If A Cell Contains Specific Text in Excel
=EXACT(A2,B2)

If the two strings are identical, EXACT will return TRUE. If not, EXACT will return FALSE. You can use this result inside the IF function to display a message or make a conditional calculation. For example, to display the message “Yes” for a match and “No” if not, use:

=IF(EXACT(A2,B2),"Yes","No")

Note the EXACT function is case sensitive. If you don’t care about case, you can simply use the equal sign like so:

=A2=B2

Visit: Case-sensitive and case-insensitive ways to Compare Text in Excel examples.

Worked Example:   Highlight numbers that include symbols in Excel

This formula will return TRUE or FALSE, and will treat “Apple” and “apple” as the same.

Worked Example:   Find most frequent text within a range with criteria in Excel

Post navigation

Previous Post:

How to check cell equals one of many things in Excel

Next Post:

How to abbreviate names or words in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count total characters in a range in Excel
  • Replace one character with another in Excel
  • Put names into proper case — Manipulating NAMES in Excel
  • How to extract text between parentheses in Excel
  • Excel MAX, MATCH and ADDRESS function illustration
  • Get month name from date in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Assign points based on late time in Excel
  • Dynamic date list in Excel
  • Count birthdays by month in Excel
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles