Extracting a word from a cell

I work for an Automotive IT Comapny and I'm trying cross check all the charges we make against what we are charged by a 3rd party supplier. Of course what we narrate in our billing is different to what they narrate, so I'm trying to extract the franchise from their text to then be able to do the cross checking with our narration on our invoicing.

I've tried to use formula's such as Search, Left, Right, but I want a column to actually display the outcome of which franchise we've been charged for, not just that there is a franchise in the text cell. The Left/Right formula's don't work due to length of the franchises and their different descritions in the narration.

Is there any way I can achieve what I'm after? Thank in advance.

I've attached a sample of what I am trying to achieve. (Note. I have now included a few examples of what I want to achieve)

This is a good start, but are we supposed to get the franchise name without something to compare against?
some are in the 4th word, some are in 3rd word, some are in last position, some in second to last position,some are unknown, so how do we decide the the franchise to look for, even if there is no multiple franchises within the description, without a list, how do we find them ?

like dredwolf mentioned, we would need a list of the franchise somewhere. say i put the list in E2:E8
Kia
Ford
Suzuki
Holden
Hyundai
Honda
Mitsubishi

then in C2:
=LOOKUP(2^15,SEARCH(" "&$E$2:$E$8&" "," "&A2&" "),$E$2:$E$8)

you're welcome. SEARCH returns the position number of what you're looking for. the max number of characters a cell can hold in Excel 2007 & above is 32,767. 2^15 will give you 32,768. so it's just a number big enough so that it returns the last number.

You are welcome, and thank you ben for the back-up