Report

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

Ask a question KICK - Latest answer on Jul 11, 2016 06:27PM
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 
Helpful
+0
moins plus
Please post your formula so that we understand what method you are using to compare!
KICK- Jul 9, 2016 01:45AM
Hi am just using equal of two cells "=A1=B1".. if it is match we will get as True unless False...
Reply
ac3mark 5897Posts Monday June 3, 2013Registration date ModeratorStatus September 29, 2016 Last seen - Jul 10, 2016 11:28AM
Convert both to the same Case using either LCASE OR UCASE, and compare the result, using your syntax:
=lcase(a1)=lcase(b1)
Reply
KICK- Jul 10, 2016 01:06PM
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..
Reply
KICK- Jul 10, 2016 02:43PM
Hi i got the answer we can Use
below function "=EXACT(A1,B1)" getting the exact output.

thanks for your support.
Reply
ac3mark 5897Posts Monday June 3, 2013Registration date ModeratorStatus September 29, 2016 Last seen - Jul 11, 2016 06:27PM
Glad you got it!
Reply
Add comment
Helpful
+0
moins plus
The method by which I was speaking, was:
=if(lower(a1)=lower(b1),"true","false")

Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!