here am trying to know something about the compare of 2 names in excel
below is my format
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.