98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Case sensitive text
microsoft+excel+training+london - Case sensitive text
Resolved · Low Priority · Version Standard
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?
Thu 1 Nov 2007, 09:59Trainer Carlos said...
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
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. |
Excel tip:Entering text in Multiple WorksheetsIf you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows: |
