ExcelBanter - Replace Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Replace Function (https://www.excelbanter.com/excel-programming/292350-replace-function.html)

Neil[_14_]

Replace Function

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?

JE McGimpsey

Replace Function

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?

All times are GMT +1. The time now is 01:55 PM.