Parse data in excel -- space delimited -- right to left

Parse data in excel -- space delimited -- right to left

1 Exxon Mobil 452,926.0 41,060.0 2 Wal-Mart Stores 446,950.0 15,699.0 3
Chevron 245,621.0 26,895.0 4 ConocoPhillips 237,272.0 12,436.0 5 General
Motors 150,276.0 9,190.0 6 General Electric 147,616.0 14,151.0 7 Berkshire
Hathaway 143,688.0 10,254.0
How do I take the above data and create four columns of data in excel?
Rank# Company Name #data1 #data2
Split Text into Columns Function in Excel
this solutions comes close ...
Where is the "read line from right to left" and use the first two spaces
to delimit text function?
Chers, Mw