One way would be to select a cell in your data field (assuming no empty
columns between data columns, and you back up your data first) and then do
Data Filter Autofilter.........then click the arrow at the top of column
B and select Word1, then select the arrow at the top of Column D and select
Word 2............this will leave only those rows which have both your Word1
in column B, and your Word 2 in column D..........then you can just type and
copy and paste the NEWWORD you want in column E of those filtered
rows..............then do Data Filter Autofilter again to turn off the
filter...........then just repeat the whole process for each
sheet...........

hth
Vaya con Dios,
Chuck, CABGx3


"Rebecca" wrote in message
...
Hi. I am very new at using EXCEL 2003 and I was wondering if the program
can
do the following: I want to search for a certain word in Column B and
another (usually different) word in Column D (both words are in the same
row), and replace a blank cell in Column E with a particular word (also in
the same row). And I would like to do this in all the sheets (that is, a
global search and replace). Could someone give me some advice as to how
this
could be done? Please explain in easy English. Thanks.