some quetion:

1.what do you mean by "word"? for example, "BSSABC" is the specific word €œBSS€�
or not?
2.if next BSS appear while copying the next 20 words after BSS, how should this
BSS be treated?

keizi

"Telecommm" wrote in message
...
Hi Experts,
Hoping you in good health. I have the following question:
I have a text file which is approximately 50 to 70 pages long. It contains a
specific word €œBSS€� again and again, what I want to do is to design an excel
sheet which takes this text file as input and finds out this required word
(which is BSS), copy the next 20 words after BSS and paste it into excel
sheet in cell B4. It should search the text file again and find the word BSS,
and copies next 20 words in cell B5 and so on.

Thanks for your support