MS Excel: How to add up values from text strings

In this video I want to show you a solution that i put together for a user request. This user had data for years and months but were type in the same cell as a text string. The request was to come up with a formula to add up the years and the months.