Excel Line Restructured

I need to be able to restructure a long text field into multiple columns of data. The text field is a mix of numbers and letters of varying lengths and spaces. For Example: 111-123456 John Q. Public 04/07/13 0.00 22.48 22.48 0.00 0.00 22.48 222-123456 Mary Jones Big Company 11/12/13 15.00 555.97 107.52 1,567.00 0.00 0.00 These two lines start with a fixed length numeric sequence (10 digits), followed my a name (varying lengths and number of spaces), followed by a date, followed by 6 sets of numbers (different lengths and includes commas for amounts of 1,000 or more). On the actual spreadsheet, the lines formatted as described above, appear every 4 to 7 lines. The intervening lines I can already manipulate to show the information required. I may be asking for the impossible. I need to learn how to break out the field into the desired columns. Learning how will enable me to handle similar but not identical lines in other spreadsheets. I need to break this line into 8 columns. Account number, name, date, value 1, value 2, value 3, value 4, value 5, value 6