I see it says you have Excel 2010, and not one of the latest versions where you might be able to use PowerQuery or some of the new text functions rolling out.
This was helpful for me doing a similar thing. And I learn well by watching videos like this:
https://www.youtube.com/watch?v=zpmnBuR7uXs
Best,
Ann