Edit specific content from multiple cells in Excel

Anonymous
2022-08-04T21:49:32+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-08-04T22:04:07+00:00

    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'.

    4 people found this answer helpful.
    0 comments No comments
  2. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2022-08-05T23:14:26+00:00

    Hi,

    This screenshot should say it all.

    Hope this helps.

    4 people found this answer helpful.
    0 comments No comments