Learn Excel Episode 160: Get characters after the Dash

Posted in Companies, Podcasts on June 28, 2008


Learn Excel 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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel