Wild Card search with space ??

Originally Posted by oldtech

I want to do a global replace of .com .net .org etc.... using .???
The issue i have is how to include the space at the end.

eg.

change '.com ' to '.com;'
'.net ' to '.net;'

I have tried single and double quotes but it does not work!
If i want to change .??? to .???;
The downside of using .??? is if i have an email of :
bob.slocom@gmail.com it gets change to:

bob.???;@gmail.???;

All i want to do is add a semi colon to the end of all emails.
Thanks

If these domains are listed in a column or two, you can use a helper column that "adds the semicolon on the original text" with a simple formula like =A1&";"

then you can copy|Paste Special >> Values over the original and delete the helper.