What I mean is:

0001 Firstname Middlename Lastname 5434500
0002 Firstname Lastname 4500500
0003 Firstname Middlename SecondMidname Lastname 100

The name length is variable (obviously) and everything is separated by single spaces.

I want column A to contain the person count, B to contain all names and C, the number:


0001| Firstname Middlename Lastname _____________ | 5434500|
0002| Firstname Lastname_________________________ | 4500500|
0003| Firstname Middlename SecondMidname Lastname | 100 |

By choosing space as delimiter, I can't put an entire name in a cell. Each name occupies a cell.
Excel's import dialog doesn't seem to give this option.