Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ben1637
  • Order by date
  1. Ben1637

    Splitting an Excel column into 2 columns

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

    Splitting an Excel column into 2 columns

    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...
  3. Ben1637

    Validation List in Excel 2000

    That's great - thank you, Kevin!!
  4. Ben1637

    Validation List in Excel 2000

    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...
  5. Ben1637

    Sporadic Printing Problems

    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...
  6. Ben1637

    CLEAN Function in Excel 2000

    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...
  7. Ben1637

    CLEAN Function in Excel 2000

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

    CLEAN Function in Excel 2000

    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!!
  9. Ben1637

    CLEAN Function in Excel 2000

    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...
  10. Ben1637

    Variation of BackUp Macro Question in Word 2000

    FANTASTIC! Thank you VERY much for your help!
  11. Ben1637

    Variation of BackUp Macro Question in Word 2000

    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...
  12. Ben1637

    Macro to BackUp File in Word 2000

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

    Macro to BackUp File in Word 2000

    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...
  14. Ben1637

    PowerPoint 2000 Action Settings Colors

    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...
  15. Ben1637

    Link to Middle of Page in Acrobat 6.0

    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...
  16. Ben1637

    Close Find and Replace Dialog box

    Hello Everybody! I have created a Command Button on a form to Find a Record (using the wizard, Category = Record Navigation and Action = Find Record). It works perfectly in the sense that when I click the button, it opens the Find and Replace dialog box and I can then type in my search...
  17. Ben1637

    Undo track changes in Word 2000

    Hi Everybody! The tracked changes on a very detailed document were accidentally accepted (by clicking Accept All) before the tracked document was saved. Unfortunately, I need to send the tracked version to a client. Is there any way to recapture the tracked changes in the document? I...
  18. Ben1637

    Delete Archive

    Hi Everybody: My company uses Lotus Notes 5. I am trying to reimage the computers used in our training room. Each computer has it's own training id file (.nsf). Since Archiving has been taught in the past, the archive bookmark, settings, etc. have already been established. How can I get rid...
  19. Ben1637

    PDF not displaying properly in Reader

    Hi Everybody: I converted a Word document to PDF using Acrobat 5. Once it was in PDF format, I added links (using the chain button on the toolbar) adding some interactivity to the document. What's strange, however, is that when I associated a link to a picture (to jump to a diff view), it...
  20. Ben1637

    The Form Name is mispelled...Error message

    That's it! It was being called at Startup. Thank you SO much!

Part and Inventory Search

Back
Top