Copy the text strings into column A of the second sheet.

Now use Data > Text To Columns > Fixed Width to split them out. Set the break points on page 2 of the wizard.