One way:

variable1 = Application.Substitute(variable2, "text1", "text2")

In article ,
"Neil" wrote:

I have developed a spreadsheet utilising vba in excel XP. I now discover that
the Replace function does not exist in excel 97. I am using the replace
function like this:

variable1 = Replace(variable2, "text1", "text2")

What code can I use to have the same effect and function in excel 97 and XP?