Printable View
Hi,
Is there any way to replace a certain string inside of a string, but only once. Right now I'm using replace(WholeString, WhatToChange, ReplaceWithWhat) but it's changing every instance. Can I have it replace only the first instance in the string?
Thanks!
I don't have VB at the moment but I think Replace() function allows to specify number of occurences you wish to replace - default is ALL.
Duh for me!
The webpage references I found didn't make any mention of it, but I got it now. Thanks!
is this in vba? looks like find and replace for word or excel