Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft+excel+training+london - case sensitive text

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

ResolvedVersion Standard

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?

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.