worksheet function - 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