Delete everything from a certain word onwards


T

Thomas

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

Advertisements

S

Sean Timmons

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

Mike H

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
 
S

Shane Devenshire

Hi,

If all your entries are in the same case
=LEFT(A1,FIND("Feb",A1)+2)
where Feb is entered in the same case as the data in column A.

Another formula that works but is longer

=REPLACE(A1,FIND("Feb",A1)+3,99,"")
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top