String - Is in the string & Replace it

[wwj]

Code: Select all

If InStr(MainString, SubString) <> 0 Then

https://wellsr.com/vba/2016/excel/use-v ... substring/

Code: Select all

Replace ( string1, find, replacement, [start, [count, [compare]]] )

https://www.techonthenet.com/excel/form ... ce_vba.php