Making Excel Case Sensitive

**spacecityguy** · 06-03-2009, 04:31 PM

Is there any global option/config file setting I can toggle to make Excel case sensitive? I'm familiar with the function exact() for text comparison but want to know if there's a way to make Excel treat upper and lower case differently.

Thanks.

**starryknight64** · 06-03-2009, 04:40 PM

What do you mean?

Case sensitive as in filenames, variable names, cell names, etc?

**spacecityguy** · 06-03-2009, 04:48 PM

Variables and cell contents. For example, I want "Apple" and "apple" to be 2 rows in a pivot table.

**starryknight64** · 06-03-2009, 04:54 PM

Variables cannot be case sensitive in VB 6.0 (the version used by most Office applications--that I know of...)

Generally, just tack on an index or an underscore and you get a different (but similar) variable name. What exactly are you trying to do that would make you want variable names to be case sensitive?

As for the cell contents of "Apple" vs. "apple"... that should be do-able. What exactly are you doing to make it default to "Apple" (or "apple"--depending on which was first)?

**spacecityguy** · 06-03-2009, 04:55 PM

Well, it's really my source data that created "Apple" vs "apple." In some cases, I need to separate the two, and that why I posted the question. Thanks a lot for lending a hand.