Lookup and Change

[rollover99 via OfficeKB.com]

I need to find specific words in a cell in a worsheet in a column
and change the cell to equal “L3”

 

[Sherry]

I think you can try find under edit and go from there

 

[tcgaines]

this could help me too... what if you want to change the value if its
less than 0?

thx