I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
--
JerryG

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
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"JerryG" wrote:

I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
--
JerryG

=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

"JerryG" wrote in message
...
I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
--
JerryG

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

Regards,
Stefi


€žJerryG€� ezt Ã*rta:

I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
--
JerryG

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


"JerryG" wrote in message
...
I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
--
JerryG