Search and Find - To extract some text from a string of text

Good afternoon all,

I have strings of text that I need to extract some text from that is not in a uniform manor.

For example, I have a car description of Peugeot 207 1.6 GTi, That I would need to turn into just 207.

I have tried to use Search and Find but cannot make it work, am I using the correct functions?

Please take a look at the attached example.

In column B is where the formula would sit, looking at the text in column A.

I have entered in manually the results I would expect.

In column G, I have put the only model cars I am interested in.

Thanks in advance.