Is there some "rule" as to where to split them?
If it is always at the same spot (i.e. the 5th character) or there is some delimiter (i.e. comma), then you can use the Text to Columns functionality under the Data menu to split one column into two columns.