Replace Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top