Header Ads Widget

Compare Two String-Excel


If you want to compare two string in excel for the finding is they are same or not you can use EXACT function, for example, if you want to compare
A3 with B3 use formula as
Compare Two String-Excel


Compare Two String-Excel

IF the two string are identical, EXACT will return true else it will return false. If you want to change the result true or false to any customize you can use
EXACT function within IF function

like =IF(EXACT(A3,B3),"OK","NO")

Note that EXACT function is case sensitive, if you do not care on spelling and case it will return false match

if you want to don't care for the case you need to do like this
This formula will return true on both Dell and dell to Dell and Dell

Compare Two String-Excel

Post a Comment