Comparing the two names respective of Upper & Lowercases letters [Solved/Closed]

Report
-
 Blocked Profile -
Hello,

here am trying to know something about the compare of 2 names in excel
below is my format

Http:CCM_net_C2E http:cCM_Net_c2E

i have compared 2 but getting the result as "TRUE" only.
as per our perspective it is wrong because some of them are in caps and small
so in this case could you please suggest the best way for comparing the same.
thanks in advance.

2 replies


Please post your formula so that we understand what method you are using to compare!
Hi am just using equal of two cells "=A1=B1".. if it is match we will get as True unless False...
Blocked Profile
Convert both to the same Case using either LCASE OR UCASE, and compare the result, using your syntax:
=lcase(a1)=lcase(b1)
> Blocked Profile
Hi I have checked your comment but here you are converting the Lowercase or Uppercase. in that case also it will show the True.
but i need here to check every letter and finally need a output.
See "Http:CCM_net_C2E"
"http:cCM_Net_c2E" it is a combination of Lcase and Ucase. in this case i have to get False because diff b/n Lcase and Ucases.
So please suggest your idea on this.
Thanks in advance..
Hi i got the answer we can Use
below function "=EXACT(A1,B1)" getting the exact output.

thanks for your support.
Blocked Profile
Glad you got it!

The method by which I was speaking, was:
=if(lower(a1)=lower(b1),"true","false")