SUBSTITUTE Function for a range

Originally Posted by popipipo

Try to do it this way:
CTRL H Find (.net) and replace (.com)

As stated in the original post I would like to avoid having to find and replace everyday and would like to find a way that it would automatically replace all occurrences