Well using the Left, Mid & Right string functions is the usual method for doing what you want, especially when coupled with the Instring Function to find the headings and the Len Function to get the overall length of the string.
However if the format of the data is fixed then it is simple enough to just use left, right & mid.
You can also use the VarSplit Function and place the data into into an array based on the spaces before working on those first 4 shorter strings to obtain the parts you want.