To define the point where the Replace function starts searching the string, include the number of characters you wish to start from in the command. Not only does this example only replace the second ...

About 5 months ago, I posted a mini-article entiteled "Improving the InStr Function". Here is the link to that article (which I also posted to some Excel groups as well)... https://lnkd.in/eCAnVKXR ...