How to compare Text in Excel

Comparison of text between cells is possible in Excel through an Excel Formula. Exact function helps in comparing 2 cells, to check if the values within the cell is matching exactly. This function can be very helpful, as various use cases like comparison of email address, comparison of 2 addresses, or anything else can easily be done. How to compare Text in Excel? How to use Exact function in Excel? learn in easy steps with the help of this article.

John has customer spend data for his company. He is looking forward to compare two columns, Email_1 and Email_2. He wants to check if the values within the two column is same. There can be minor variation within the two emails, and John wants to know which ones has differences and which are the same.

Compare two text in Excel with Exact function

• Step 1: The first parameter of Exact function is “text1” to compare. “text1” is the cell which contains first Text value. For this example it is Email 1 i.e. cell G5. So we will be entering the same.

                  =EXACT(G5, )

• Step 2: The second parameter is “text2”. “text2” is the cell which contains second Text value. For this example it is Email 2 i.e. cell H5. So we will be entering the same.

                  =EXACT(G5, H5)

Step 3: Copy the cell I5 and paste the formulas to rest of the cells in the column. This will generate updated Check column for whole table.

To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.

Please visit our video tutorial to go through the example as well:

Share your feedbacks if you like the article. Like and share for more such content.