MS Excel- Can this be done

Ok gang I’ve got a puzzler for you.

I was assigned a project and was given an excel spreadsheet with some data on it which I need to convert to a database and web enable it. This part is no problem.

Here’s the problem. The one column of the spread sheet contain multiple two character codes separated by a forward slash.

eg. AB/CD/EF

When I import this spreadsheet into the database I only want one code per record

eg. AB
CD
EF
otherwise the reports we run against the database will not be acurate. I know I can do a manual cut and paste row by row and make my edits, the question is, is there some automated process I can use to do this for me?

This will knock days off the project. Help? Thanks.

Jim