Excel question...didnt know where else to post

to start, sorry for posting on kirupa…i just dont know where else to post it…

simple quick question:

i have an excel file with two columns…one has the company name and the other has 5 numbers in it but using Wrap Text.

i need to break up the 5 numbers in the second column into 5 separate columns so that i can export it over to mysql…

i tried using the Text to Columns feature, but there is nothing there to change Wrap Text items into multiple columns

any thoughts?