Well I was working with the Exact Function in Excel 2007 and wondering why I am getting a two different results?
Lets Have a "Word" in one cell(Say A1) and "word" in other cell.(Say A2)
Use the Formula "=Exact(A1,A2)" and the answer should be false and it makes sense as the Exact Function is Case Sensitive.
Now in Cell B1 put this formula "=Propoer(A1)" and result should be "Word"
Cell B2 --- "=Proper(A2)" and result "Word"
and Cell B3 --- "=Exact(b1,b2)" result will be True
But when the try to combine the three Forumlas B1,B2,B3 in to one Like
in cell A4 use this formula "=Exact(proper(A1),proper(A2))" it give a result False..
Any one know the reasoning behind this?