Do you mean the three or more names are to be in the same cell?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.