{"id":5034,"date":"2020-03-09T18:36:24","date_gmt":"2020-03-09T18:36:24","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=5034"},"modified":"2024-02-19T14:52:36","modified_gmt":"2024-02-19T14:52:36","slug":"compare-two-strings-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/compare-two-strings-in-excel\/","title":{"rendered":"Compare Two Strings in Excel"},"content":{"rendered":"\n
To compare text strings in Excel, you can simply use the comparison operator (=).<\/p>\n\n\n\n
=A1=B1<\/code><\/pre>\n\n\n\nComparing strings with EXACT<\/h2>\n\n\n\n
The EXACT function works similarly to the comparison operator, but there are some differences between these two approaches.<\/p>\n\n\n\n
The function takes two parameters, which represent two strings.<\/p>\n\n\n\n
=EXACT(string1, string2)<\/code><\/pre>\n\n\n\nLet’s compare these two methods using this example:<\/p>\n\n\n\n