Delete everything from a certain word onwards
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,"")
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"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.
|