My question is for beginners but I am working with spreadsheets and documents
which contains a lot of the same words I want to delete. Can anyone please
tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!

Here's one quick play using SUBSTITUTE for progressive deletion ..

Assume text data is running in A1 down

Enter the exact words/phrases (case sensitive) you want deleted in say K1
down. Eg assuming you have 3 words to delete:
in K1: the, in K2: Oops, in K3: milk

Then place in B1:
=TRIM(SUBSTITUTE(A1,INDEX($K:$K,COLUMN(A1)),""))
Copy B1 across by 3* cols to D1, fill down as far as required
*copy across by the no. of words/phrases to be deleted in col K

The "final" col D will return the results that you're after.

Col B deletes the 1st word input in K1, col C deletes the 2nd, and col D
deletes the 3rd, and so on.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"v" wrote:
My question is for beginners but I am working with spreadsheets and documents
which contains a lot of the same words I want to delete. Can anyone please
tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!

This is probably too easy, but in the absence of much detail, try this method.

EditReplace

what: word to delete

with: nothing

Replace all


Gord Dibben MS Excel MVP


On Tue, 27 Feb 2007 17:02:05 -0800, v <pleasehelp wrote:

My question is for beginners but I am working with spreadsheets and documents
which contains a lot of the same words I want to delete. Can anyone please
tell me how I can do this? THANK YOU BEFOREHAND FOR YOUR HELP!