extract text from string

[LFKim2018]

how could I extract to 3 columns the following string format?
DATE SAMPLE OF STRING AMOUNT

first text is before the first occurrence of the space
2nd text is between the 1st space and the last space
3rd text is after the last space

say string is at A2
B2 = DATE
C2 = SAMPLE OF STRING (can contain more than 3 words)
D2 = AMOUNT

many many thanks

 

[LFKim2018]

thank you very very much!

 

[LFKim2018]

Try this...

=MID(LEFT(A2,LEN(A2)-LEN(D2)-1),LEN(B2)+2,99)

Mr. Rothstein
I just noticed that the MID is extracting the number 25...
many thanks

https://www.dropbox.com/s/qkri5fzs1712x9c/extract error mid.PNG?dl=0

 

[LFKim2018]

could it be because the formula is referencing to D2 - can we reference it back to A2?
the column D is formatted to show numbers and comma.... could this be the problem?
many thanks

 

[LFKim2018]

Mr. Rothstein
sorry to be this pesky.
I removed the formats and it worked well.
many many thanks