String operations in VBA for "Substituite"?
What is the best way to code VBA for the associated SUBSTITUTE command in
cell formulas...
I want to delete a character from my string. I usually achieve this by
using
=SUBSTITUTE(²text²,²t²,²²)
Which returns ³ex² in a cell.
Unfortunately, this doesnıt go well in VBA ...
Perhaps the followoing?
For j = 1 to len(str)
If Mid(str, j, 1) = "t"
delete the letter of the string?
Else??
Any ideas? Iım sure someone has done it before ...
|