Recent content by Ben1637

This is great! Thank you very much...it's working perfectly.

Hi Everybody, I use Microsoft Excel 2000 and I'm pretty sure what I'm trying to do is possible, but I can't seem to figure out how to do it. I received a bunch of data from a survey that had some open ended questions in a text file. I used Excel to open it and was able to put most of the data...

That's great - thank you, Kevin!!

Hi Everybody, I created a combo box in Excel by using the Validation function (Data --> Validation --> List). It's a simple drop-down menu with 'Yes' and 'No' as the two choices. However, I would like to include a blank option so if a person accidently chooses Yes, they could change their...

Hi Everybody, I use Acrobat 6 Professional. I am having some very strange, sporadic printing problems that are driving me nuts. Any help and/or suggestions you may have would be greatly appreciated. The PDF was originally converted from Word. It's ultimately several documents pieced...

Dale, it worked!! Thanks so much! Your workaround was certainly much easier than trying to figure out a formula. :) THANK YOU VERY MUCH!! Blue Dragon, you're right, if all of my cells had that apostrophe the sort would have worked, but unfortunately, the apostrophes were sporadic. Thanks...

When I type that formula into a new cell, it returns a number 6 (i.e. the number of real characters)

I tried Find/Replace and didn't have any luck. Can you please help me with the syntax? Does it matter that the character doesn't display in the cell, but rather just up in the formula bar? Thanks!!

Hi Everybody: I have a spreadsheet in Excel 2000 that has data imported from another system (maybe Oracle?) and I am trying to sort one of the columns. Although the data looks fine at quick glance, when I click on the individual cells, I can see up in the formula bar that many of the cells...

FANTASTIC! Thank you VERY much for your help!

Hi Everybody: With your help, I was able to modify my macro so it: 1.) saves the file I'm working on to the A:\ drive (i.e. creates a backup of the file) 2.) Returns to the file where I was working on it (i.e. File --> Save As again and switches back to the file on, say, the H:\ drive) I was...

Thanks SO MUCH, YoungCougar!!!! It worked perfectly.

Hi Everybody: I am trying - and failing - to create a macro that will: 1.) save the file I'm working on to the A:\ drive (i.e. create a backup of the file) 2.) Return to the file where I was working on it (i.e. File --> Save As again and switch back to the file on, say, the G:\ drive) This is...

Hi Everybody: When using Action Settings in PowerPoint 2000, how can I customize the color of the "Highlight Click" and "Highlight When Mouse Over" options? The highlight color seems to change when I make the original object a different color, but I don't see how to choose my own highlight...

Hi Everybody: I am trying to insert a link, bookmark, destination (not sure what) to my PDF so it jumps down to the middle of a subsequent page, but I can't figure out how to do this. What am I missing? In Acrobat 5, it was very straightforward to insert a link that jumped down to another...