the way I used to fix this was a feature called something like 'text to field', where you pick a cell, and you can spread it out to many cells using a delimiter such as comma or space
To separate fixed-width text into multiple columns, follow these steps:
Highlight the range of cells that includes text to be separated.
Go to Data, Text to Columns.
Select Fixed Width from step 1 of the wizard and click Next.
Excel will guess at where the column breaks should go, as shown in Figure 3.9.