How to find multiple cells/replace whole cells w/data

[Guest]

I am trying to find a specific set of characters in multiple cells in a
column. Once found, I need to replace the data within found cells with a
specific text string. I have been able to replace a text string, but not the
whole cell.

 

[Dave O]

Perform a search and replace, and add an asterisk before and after your
"search for" parameter. Replace with your desired cell contents.

Search for: *your text here*
Replace with: desired cell contents

 

[Guest]

Instead of 'Find', turn on data filters and select Custom... Use the
drop-downs to make the condition 'contains' and then enter the set of
characters in the text box. Now only the appropriate rows should be shown,
so type the replacement text in the first matching cell and drag it down,
copying it to the remaining rows.