Previous Topic Next Topic

Comparing the two names respective of Upper & Lowercases letters

Solved/Closed
KICK - Jul 8, 2016 at 06:30 AM
 Blocked Profile - 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.
Related:

2 responses

Answer 1 / 2
Blocked Profile
Jul 8, 2016 at 09:10 AM
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...
Blocked Profile
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)
KICK > Blocked Profile
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..
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.
Blocked Profile
Jul 11, 2016 at 06:27 PM
Glad you got it!
Answer 2 / 2
Blocked Profile
Jul 11, 2016 at 06:25 PM
The method by which I was speaking, was:
=if(lower(a1)=lower(b1),"true","false")

Similar discussions

How to get capital letter in Nokia 2700 model
ppn -
ruby -

2 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
Keyboard typing letters and numbers at the same time
Hottie -
Isebas -

37 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses