Edit specific content from multiple cells in Excel

Question

What I basically want to do is to erase a piece of text under a group of cells, without changing anything else.

IE:

https://drunk-robots.com/?utm_source=PlayToEarn.net&utm_medium=organic&utm_campaign=gamepage
https://playposeidon.io/?utm\_source=PlayToEarn.net&utm\_medium=organic&utm\_campaign=gamepage

Id like to be able to delete "?utm_source=PlayToEarn.net&utm_medium=organic&utm_campaign=gamepage" from both without changing the rest of the URL, is this possible?

Answer 1

Select the cells.

Press Ctrl+H to activate the Replace dialog.

Enter or copy/paste

?utm_source=PlayToEarn.net&utm_medium=organic&utm_campaign=gamepage

into the 'Find what' box.

Leave the 'Replace with' box empty.

If necessary, click 'Options >>'.

Make sure that the check box 'Match entire cell contents' is not ticked.

Click 'Replace All'.

Answer 2

Hi,

This screenshot should say it all.

Hope this helps.