Hi Jerry,
You can use SUBSTITUTE or REPLACE function.
for Example: if you want to search and replace 1 in the following value
entered in cell A1:-
abc1defghij1klmno1pqrstuvw1xyz
Use formulae =SUBSTITUTE(A1,"1","")
Please let me know if this helps.  Thanks

=IF(ISNUMBER(FIND("old text",A2)),"new text",A2) if you want the search to
be case sensitive,
=IF(ISNUMBER(SEARCH("old text",A2)),"new text",A2) if you don't.
--
David Biddulph

Enter this formula in an empty helper column
=IF(ISERROR(FIND("texttosearchfor",A2)),A2,"givenstring")
and fill it down as necessary. You can Copy-PasteSpecial/Value the result
back to the original cells.

Regards,
Stefi

„JerryG” ezt írta:

I'm guessing you want to do that to the cell's content itself. Try this.
Select all the cells you want to do this to and then click Edit/Replace in
Excel's menu bar. Assuming for this example that the text you want to find
is "find me" (without the quote marks). Put this in the "Find what" field...

*find me*

then put the replacement text in the "Replace with" field. The key to
replacing the entire contents using Replace is the asterisks on both  sides
of the text you are search for.

Rick