Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Case sensitive text
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft+excel+training+london - Case sensitive text
Resolved · Low Priority · Version Standard
Reply Tue 30 Oct 2007, 16:13Delegate James said...
James has attended:
Excel VBA Intro Intermediate course
Case sensitive text
When comparing text does it matter if both names are not in the same case?
For upcoming training course dates see: Pricing & availability
RE: Case sensitive text
James
Yes. It can matter.
Excel compares the binary values of text as default (eg "A" does not equal "a")
To compare text as default write
Option Compare Text
in the General / Declarations section of the code window
Carlos
|