Excel txt file import when column headings and data values are always right-aligned

Excel txt file import when column headings and data values are always
right-aligned

I have a large txt file, which consists on a matrix in which column
headings and data values are always right-aligned. This is the only
"regular feature" I can find to allow for importing the txt to excel,
because elements are separated by an irregular number of spaces depending
on the size of the data numbers.
The matrix has empty cells in several positions. It looks like this:
4536 4705 2360 2355 2717
56099 5156.5
12470 4114.9
12469 23.0
56997 2311.9
12471
12479
12473
12478 41.1
12484 78957.7
12477
12483
12476 7125444.9
Any suggestion on how to do the import with VBA? How can I call for the
condition of being aligned to the right? Thanks.