Extracting random length data from a random length string

[Hoops]

I'm hoping to extract the vehicle year, make, and model from the following data:

Model Number: TAS-2570E^
Vehicle Year: 2012
Vehicle Make: HONDA
Vehicle Model: ODYSSEY
Position: Front Alotmorerandomtext

Seperate issue...The text above is in one cell like shown in the attached image, but when I copy/paste this into this forum or Word, it adds formatting like shown above.

Anyways, getting the year was fairly easy using the mid function, but with every make and model being different character lengths, what can I do to pull Honda and Odyssey out into seperate cells?

Capture.JPG

[Pepe Le Mokko]

Perhaps post a sample sheet