Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Faizee from Youtube posts a question about looking for certain words in a cell in order to create a category. While this sounds simple, Bill and Mike manage to come up with a number of possible formulae in Episode 1055!
posted by Bill at 9:00 AM
Episode 954 brought an avalanche of mail on three fronts. (1) SendKeys is really cool, how do you do Alt instead of Ctrl? (2) Why the macro when you could select Entire Workbook in the dialog? (3) Application.Dialogs would have worked, the dialog is misnamed. Episode 957 discusses all of these tips.
posted by Bill at 9:00 AM
The Find command seems to work perfectly with text, but always has problems with finding numeric values. It is possible to find numbers with the Find command in Excel, but you have to know some fairly arcane steps. Episode 522 shows you how.
posted by Bill at 9:00 AM
Rod calls in a question today; how to use conditional formatting to highlight all the track athletes from a particular school. This requires the conditional format to look for the school name within a cell. This is very easy in Excel 2007 but very difficult in Excel 2003. Episode 517 discusses the functions required to make it work.
Labels: conditional formatting, Find, ISERROR
posted by Bill at 9:00 AM
Jason sends in our question today. He has a single column of cells that contain 5 bits of information in each cell. There aren’t any good delimiters and the fields are not fixed width. To extract the necessary information from the cell, Episode 479 shows how to combine MID, FIND, and FIND to locate the important data.
posted by Bill at 9:00 AM
