Can I format a subExpressionString of a RegEx replaced text? So if the searchPattern is “(\d+)?”, and the input is “0”, “00” or “000”, I always want the output to be with three digits (“000”). How could this be achieved?
f.e. Format( Cdbl( subExpressionString(x) ), “000” ), but i am sure @Kem Tekinay knows a much smarter way
I do not.
Oh, the last hope…
Makes me feel a bit more like a Pro