Just realised that Excel does not strip out leading or trailing spaces in the names for different sheets.

I am going to have so much fun sending out documents with several sheets, all called sheet

"Sheet" != " Sheet" != "Sheet " != " Sheet "

The ensuing telephone conversations should be fun .....

"You want the sheet callled space sheet space ... no, not space sheet, you want space sheet space."

Gawd, I need to get out more!

How did the spaces get there in the first place?

I put them there silly.

In most other MS products, leading and trailing spaces are truncated.

And, you normally  get namespace collisions if you try and have more than one sheet called the same thing. Using spaces is a workaround, and is not immediately obvious. Wonder how long it will take people to realise just how I managed to get several sheets called the same thing in one document.

Using the big bar at the front side of the keyboard

Yeah, there's a software engineering principle that basically says "Don't name things ALMOST EXACTLY the same, differing only by upper/lowercase, or by adding/subtracting underscores, because this becomes a maintenance nightmare."

There are exceptions to this rule -- in C++, conventions say a Class starts with an uppercase character, but instantiated objects of that Class (variables, in other words) should start with a lower-case letter.  Or is that Java?

Anyway, adding/removing spaces to make virtually identical, yet separate names, is not recommended either.  But I guess you're finding that out by experience.

Or, he knows it (isn't finding it out) and is doing it on purpose.

Duh.

Nice to see you posting again, Tapiwa.  How's your mom?

"And, you normally  get namespace collisions if you try and have more than one sheet called the same thing. Using spaces is a workaround, and is not immediately obvious."

What's wrong with actually using unique, meaningful names?  Playing around with space-driven variations on $Sheet1 is just looking for trouble, no?

i think you missed the point, dana. He IS looking for trouble.

JESUS CHRIST NO SHIT YOU GUYS ARE SO INFORMATIVE AND HELPFUL.

*Obviously* the whole point is to CAUSE TROUBLE.  Do you think he's doing it in the hopes that it will NOT cause confusion???!!

bu ... but ... that's WRONG!

>How's your mom?
Last time I checked, she was still dead.

>bu ... but ... that's WRONG!
I know, but there are some morons I deal with that need that sort of joke played on them. Only for trivial stuff though.
<evil grin>

>> "Don't name things ALMOST EXACTLY the same, differing only by upper/lowercase, or by adding/subtracting underscores, because this becomes a maintenance nightmare." <<

Tell me about it.

Clearcase version control system: Case sensitive.
Windows file system: Not case sensitive.

Junior developer checks in directory with name differing only by case.  Consternation ensues for entire team.

Case sensitivity is a bit moronic.

http://crazyontap.com/Topic.php?TopicId=20279&Posts=11
gives moron page

http://crazyontap.com/topic.php?TopicId=20279&Posts=11
works

Diff?? topic.php vs Topic.php

Moronic

>Case sensitivity is a bit moronic.

Blame apache.

Blame 'C'.  Pascal was never case sensitive.

I had a better one. The users didn't like their leading zeros stripped when the .CSV file was double clicked, and they didn't want to format the columns. So, I concatenated the 0xA0 character to the beginning of the number and voila! the leading zeros remained, and everybody was happy.