Application.substitute
Hi Robert,
Am Sat, 28 Sep 2019 13:11:20 -0700 (PDT) schrieb RG III:
I'm able to read a text file into a variable. Now I want to do a search and replace of ALL instances of the word "bitch". Using Application.substitute() I'm able to replace the first occurrence of the target string, but I want to replace ALL occurrences with "#####".
How do you get Application.substitute() to search and replace multiple instances of a target string? Or is there a better method?
try:
myStr = Replace(myStr, "bitch", "####")
Regards
Claus B.
--
Windows10
Office 2016
|