Replace Function

[Guest]

I want to be able to replace all occurences of "/" with "-" in VBA.

how do i do that? what function should i use?

i could use instr() to search, and then manually replace that. was wondering if there is a better way of doing that.

tks folks for ur help

 

[Russell Hauf]

On 2002-02-21 10:22, Anonymous wrote:
I want to be able to replace all occurences of "/" with "-" in VBA.

how do i do that? what function should i use?

i could use instr() to search, and then manually replace that. was wondering if there is a better way of doing that.

tks folks for ur help

If you have Excel 2000, you can use the replace function. Otherwise, you can do something like this:

Do While InStr(MyString, "/")
  Mid(MyString, InStr(MyString, "/"), 1) = "-"
Loop

Hope this helps,

Russell

 

[NateO]

How's this (an example):

MsgBox WorksheetFunction.Substitute("2/12/2002", "/", "-")

Cheers,

Nate
This message was edited by NateO on 2002-02-21 10:36