Hi,
basically the function you need you will find here: "Data / From text". Try this and the help function attached to it. This is the corresponding function in Excel 2007.

To guide you through each step would unfortunately cost me too much time. Now you know the way to start. I am sure you find your way to a good final solution by this. Good luck!

Kind regards
Bjorn