in reply to split cells

Could it be that this excel file is the result of incorrectly importing a (comma/space/tab) separated file into excel?

If yes, I'd recommend fixing the import in the first place (you can configure the separator in excel directly) instead of fixing up the resulting file in another step.