Parse data in excel -- space delimited -- right to left
Solution 1:
I'd do this in two steps.
- The data appears to use five spaces to delimit, so I'd do a find and replace in a text editor replace any string of five spaces with a "safe" character, such as a tab or a pipe (|)
- Open the file in Excel, and select the appropriate delimiter or use the Data > Text to Columns