| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you have a value created by a function replace the function? | Excel Worksheet Functions | |||
| Replace function!!!!!! | Excel Discussion (Misc queries) | |||
| REPLACE FUNCTION!!!!!! | Excel Discussion (Misc queries) | |||
| Using the replace function less | Excel Worksheet Functions | |||
| Need Help with Replace Function | Excel Worksheet Functions | |||
Threaded Mode
