Episode 160 - Get characters after the Dash

Yesterday's podcast showed how to use LEFT and FIND to get all of the characters before a dash. What if you need all of the characters after the Dash? There are a couple of options. The first option discussed in the episode is to combined MID, FIND, and LEN to get the characters. Alternatively, you can use TRIM and leave off the LEN function. Or, in Excel 2003, just leave off the LEN function. Episode 160 will show you how.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!