Extract 2 words right and 2 words left from a sentence of a cell

[shivachary]

Hi All, can any one please help me get the below result in excel ?

Sentence :

Again, this company is the best and pioneer on the trend. This is the reason why I will recommend this company.

<tbody>
</tbody>

From the above sentence, if i find the word company, i need to extract 2 words left to it and 2 words right to it.

Ex: Again, this ( 2 words left)
company (the word to be searched for)
is the ( 2 words right)


Notice : the word company is repeated at the end of the sentence too, you may ignore that instance,


Thanks in advance.
Iam doing sentiment analysis, request some one to help.

 

[István Hirsch]

In Google Spreadsheets you can find a DETECTLANGUAGE function.