Do you have some more samples that you can provide? I worked out the Text to columns functionality in 2007 and the 1st row worked fine. Except that the text before the date got separated into 2 columns which can be merged into 1. (ghghghghghg & ghghghghg - can be merged using =A1&B1
However, the 2nd row has a "-" which makes excel think that its a formula to subtract and gives the #VALUE error. If you can provide more samples, we can look to see if we can first have a procedure to change the "-" to some other character and then merge the data in the 2 columns and then re-input the "-". (mdmgfmgm -ffffff gets split as mdmgfmgm and -ffffff which creates the problem due to the - sign).