Thank you for your solution. It appeared, that it works nicely if I just make a formula out of it, but does not work inside of macro, There I have to call some special service, and then it will work. Joshua4 explained it to me and now I understood it nicely. Still thank you for your efforts.
In the case of SUBSTITUTE() you donât have to use a helper service - just learn and remember that in BASIC this function is called REPLACE(). Yes, the set of parameters for these functions is different, but since you are going to use an abbreviated form of the call (only the first three, required parameters), you will not notice the difference.
1 Like