Excel Hints

List Unique Values from a Range

john — Mon, 26 Oct 2009 01:51:01 +0000

Excel has an easy built-in way to show the unique values from a list of numbers you provide. You can use it to filter a unique list of numbers, dates, strings or whatever you need to have listed. Using the Advanced Filter to Show Unique Values Below is the list I want to get the unique [...]

How Do I Get Just the Last Word from a Cell?

john — Fri, 09 Oct 2009 14:24:42 +0000

This is an example of a question I recently received in the comment section of a post that I think others will find useful. So the following question was asked in a post’s comment section: For example, we have the string “Let’s play a game”. Is there a fomula out there that would be able to tell me [...]

Ask Your Questions to Excel Hints

john — Fri, 09 Oct 2009 14:10:28 +0000

I receive questions all the time from readers of excel hints, both through the contact form as well as questions posted in the comment sections of posts. So let’s start sharing some of these with everyone. Going forward, I would like to work together with the readers of Excel Hints to make this a better site. If you [...]

Working with Userforms Part 1: Hello World! Button

john — Tue, 08 Sep 2009 19:21:53 +0000

Over the next few posts we will look at how to build a userform and put it to good use. Using a userform will provide additional functionality in your project that using the spreadsheet alone may not provide. One way to give your project that customized polished look, may be to incorporate the use of [...]

Change the Default Location for Saving Files

john — Wed, 26 Aug 2009 21:01:51 +0000

Here’s a quick tip I recently found that I immediately began using when I came across it. Does it seem like Excel randomly picks where to save your files when you go to save them? Do you wish you could specify the default folder that first comes up when you try to save? This quick [...]

Poll Results – Have You Ever Built a Custom Userform?

john — Wed, 26 Aug 2009 20:44:10 +0000

The results are in on Excel Hints’ 5th reader poll. Thanks to everyone who participated – the results of these polls will help shape Excel Hints in the future. We had a great response again with over 125 votes. And Now For the Results… As I mentioned before, there were 125 votes in this version of the [...]

Office 2010 Technical Preview

john — Thu, 30 Jul 2009 02:57:43 +0000

I was recently approved for the technical Preview of Office 2010. I just finished downloading and installing the new software on my laptop and plan on checking out the changes and posting screenshots in the next few days. Ribbons For anyone that didn’t like the change to the ribbons at the top in Office 2007, it [...]

Microsoft Releases Office 2010 Details

john — Tue, 14 Jul 2009 15:01:57 +0000

Microsoft has begun releasing details of its new release of Microsoft Office, called Office 2010. I’ve already signed up for the Technical Preview of the software, but unfortunately I’m still on the waitlist. With this release they are coming out with some new web functionality (similar and in direct competition with Google Docs). There [...]

Excel Hints Is Back Up and Running

john — Thu, 09 Jul 2009 03:15:43 +0000

I’d like to apologize to anyone that has attempted to visit Excel Hints in the 7 hours or so. All the links that were broken appear to be fixed now. If you were interested in the post from earlier today, click on the following link: Check if a Cell Contains Text. Again, Thank [...]

Check if a Cell Contains Text

john — Wed, 08 Jul 2009 20:03:36 +0000

Excel provides an easy method to determine if a particular cell contains text. Using the IsText function will return True or False after checking the given cell. Let’s take a look at at how to use this function. IsText Example For this example, let’s imagine Cell A1 has the text “Red”, and Cell B1 contains [...]