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?

-Robert