View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Delete everything from a certain word onwards

Highlight all cells you want, go to Find (Ctrl+F) find Feb* replace with Feb

"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.