I have a complex spreadsheet that several people use. Some of the data
in the spreadsheet includes (with example values):
Region 15
District 345345
City Abilene
Budget # 1
When the user saves the spreadsheet, he is required to use all four of
these in the filename. In this case, it would be (15)345345Abilene_1.
This is somewhat awkward to type (they have hundreds of them to do), so
I used a formula to catenate all four of these cells into one. The data
in that cell reads exactly like the file name should:
"(15)345345Abilene_1."
My idea was to save them the trouble of typing in all that garbage.
They could just select this cell, hit "Save As" and paste it into the
filename box in the "Save As" window. The problem is, when they paste
it in, it adds a bunch of spaces at the end, before the ".xls." It
looks like:
(15)345345Abilene_1 .xls.
Can somebody PLEASE tell me how to prevent this? I've tried everything
short of killing my cat...(-;
For what it's worth, some of this data is in merged cells, including
the filename cell. I tried unmerging all of them and it had no effect.
Ron M.
Bookmarks