René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

replace [VBA]

option explicit

public sub replace_()

  dim str as string

  str = "NowXthenXmore"

  str = replace(str, "X", " -- ")

  msgBox(str)  ' Now -- then -- more

end sub
See also other VBA stuff