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 :

[TABLE="width: 241"]
<tbody>[TR]
[TD="width: 241"] Again, this company is the best and pioneer on the trend. This is the reason why I will recommend this company.[/TD]
[/TR]
</tbody>[/TABLE]


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.