I recently received an email from a reader asking how to add a hidden drop down menu inside a cell. I was unable to respond back to the reader (email address was invalid), but I thought it was a great question and wanted to add it to Excel Hints.  In just a couple steps, you’ll be able to add this feature to your spreadsheet and improve the validity of many spreadsheets you create. Read more »

How many times have you tried to import a file into Excel, only to have extra blanks all over the place in the document?  Well that’s where the Trim Formula can come into play.  The Trim formula is used to clean up and remove all the leading and trailing blanks as well as all but one blank in-between text that you may have in a list of cells.  So now instead of going into each cell one-by-one, there is one formula to do all the work for you.  Let’s take a look at the formula first (it’s a short one):

=Trim(text)

This formula is very easy to use but can make you job a whole lot easier. Let’s take a look at some of the examples now.

Read more »

First of all, I’d like to thank everyone that has subscribed to Excel Hints over the last month or so. I have been a little busy with changes at my full time job as well as other websites I’m working on, so the posting on here has been put on hold for the last month and a half. Starting next week, I have it on my schedule to begin adding posts to Excel Hints again.

Again, thank you for your patience and hopefully I can get some more good tips on her that will help you with your projects. If you have any questions or comments please use the contact form or leave a comment under a particular post.

Thanks, John.