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

- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Jul 11, 2016 at 06:27 PM
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.
See more 

2 replies

Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1566
0
Thank you
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...
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1566 -
Convert both to the same Case using either LCASE OR UCASE, and compare the result, using your syntax:
=lcase(a1)=lcase(b1)
> ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
-
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.
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1566 -
Glad you got it!
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1566
0
Thank you
The method by which I was speaking, was:
=if(lower(a1)=lower(b1),"true","false")