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

Lookup and Reference Examples

  • Count rows that contain specific values in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • Two-column Lookup in Excel
  • How to use Excel ROWS Function
  • To count total rows in a range in Excel

Data Analysis Examples

  • How To Create Frequency Distribution in Excel
  • How to Create Column Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Understanding Pivot Tables in Excel

Data Validation Examples

  • Excel Data validation number multiple 100
  • Excel Data validation only dates between
  • Excel Data validation require unique number
  • How To Create Drop-down List in Excel
  • Excel Data validation must not contain

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:   Highlight column differences 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:   If cell is this OR that in Excel

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

Worked Example:   Check if multiple cells have same value with case sensitive 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 extract nth word from text string in excel
  • How to strip protocol and trailing slash from URL in Excel
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • How to get same date next month or previous month in Excel
  • Count day of week between dates in Excel
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Sum through n months in Excel
  • Dynamic date list in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • How to Calculate Tax Rates in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles