Report

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

Ask a question KICK - Last answered on Jul 11, 2016 at 06:27 PM by ac3mark
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
plus moins
Please post your formula so that we understand what method you are using to compare!
KICK- Jul 9, 2016 at 01:45 AM
Hi am just using equal of two cells "=A1=B1".. if it is match we will get as True unless False...
Reply
ac3mark 6987Posts Monday June 3, 2013Registration date ModeratorStatus May 26, 2017 Last seen - Jul 10, 2016 at 11:28 AM
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 at 01:06 PM
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 at 02:43 PM
Hi i got the answer we can Use
below function "=EXACT(A1,B1)" getting the exact output.

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

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!