Hi

I have a spreadsheet with a column of websites from where I have to remove the ones ending with certain extensions, like .edu, .gov, .us .mil etc. For doing this, I am trying to Find and Replace the text with itself but format it with a color (while replacing) so that I can sort by the color and remove them.

The problem is when I am replacing .mil with .mil (with a color) it is affecting domains with .mil extension as well as domains like .milano, .milky etc. The same happening with .us, it's selecting domains like .usa-example.com

How can I do a Find and Replace where only the last dot (.) is taken into consideration while replacing and formatting the text. So when I replace .mil with .mil (colored) it would only match domains ending with .mil extension and not consider www.milano.org ?

Hope I have been able to explain the situation properly


Thanks