Text To Columns - Separate text from number

How would I convert Text to Columns that are in different lengths to set up a rule that the text in the column would start wehre a new column would be added? In addition to this, how would I keep th...