Replace a substring using wildcard in variable

I need to replace a substring in a string in a variable.

For example, in a string that contains "&Cost=6789&" i want to replace the "6789" with a new numeric value, without knowing in advance the value (6789) that I am replacing, and without knowing in advance how long the (6789) string is.

Using wildcards, I would be replacing "&Cost=*&" with "&Cost=" & NewValue where NewValue is the value I want to replace 6789 with.

I think I found a solution eralier that didn't require me to use excel cells, but with moving between work and home computers I've misplaced it. From memory it used something like Application.WorksheetFunction.replace , but I don't recall the exact code.

without knowing in advance how long the (6789) string is.

but do you know the possible minimum and maximum length of the number? say 4 to 10?
and could there be multiple match in the string? something like "This is &Cost=6789& and &Cost=118910&"

Hi
May be

Please Login or Register  to view this content.