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.