Find & Replace cells containing specific value with another value

[tdavies93]

Hi all,

I'm looking to execute a find & replace on a dataset whereby anything containing the value 'xxx' is replaced with the value 'xxx'. For example, in a set of:
yyyxxxyyy
hhhxxxhhh
xxxhhhhhh
wwwaaaxxx
xhhaxxghh

After the find & replace, I would like the cells to read:
xxx
xxx
xxx
xxx
xhhaxxghh

Is there a way of doing this? As far as I can tell, the Find & Replace feature does not allow this and does not delete characters when a cell string contains a certain value.

Thank you for any help

 

[AliGW]

Welcome to the forum!

What's the underlying logic for the expected outcome that is last on the list? Why is it different to the others?

 

[MickG]

Try:- Find :- *xxx*
Replace with :- xxx

 

[gaz_chops]

Replace & Find is best option

Find
*xxx*

Replace with
xxx

 

[tdavies93]

Hi Thanks for responding!

The logic is that because the bottom outcome does not contain the consecutive string of 'xxx' as it does in the other cells. So if this were lists of websites, as it is in my dataset, I want to consolidate every web address containing the word 'google' to substitute for the word google.

Hope this helps! Thanks again for getting back to me

 

[AliGW]

Then try what the boys have suggested above.

 

[tdavies93]

Thanks so much MickG, this worked exactly as I wanted it to.

 

[tdavies93]

Thank you gaz_chops, this works perfectly. Thanks for the fix!

 

[MickG]

You're welcome