Hi,
To do it in the same column requires
Vb but to extract it to another column
use this and drag down
=LEFT(A1,SEARCH("feb",A1)+2)
Mike
"Thomas" wrote:
In some of about 5000 cells (all in column A) containing words and numbers
there is a certain word, for instance feb. How do I delete everything that
is located on the right side of feb? The word feb can be foumd anywhere in a
cell.