The exact command in Excel is case sensitive when comparing text. It doesn't
have to be. I can understand when comparing numbers or calculations.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

If you just want to compare something without regard to case, you can just use
the = comparison:

=if(a1=b1,"same","different")



keabu wrote:

The exact command in Excel is case sensitive when comparing text. It doesn't
have to be. I can understand when comparing numbers or calculations.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

--

Dave Peterson

Dave Peterson wrote...
If you just want to compare something without regard to case, you can just use
the = comparison:

=if(a1=b1,"same","different")
....

And even if = didn't work for text, it'd still be possible to use

EXACT(UPPER(a),UPPER(b))

to compare a and b case insensitively. If EXACT were case insensitive
and = didn't work for text, there'd be no way to construct a case
SENSITIVE comparison. Thus, it's better for EXACT to be case sensitive
than not.

The deeper problem is that the OP doesn't understand there are times
some Excel users *DO* want case sensitive comparisons.