Replace multiple substrings in string

Hi all,

I need to replace multiple 6 character substrings within a string. However, I do not know the last 2 characters of the substring. Hence, I tried using wildcards, but in vain as that doesn't seem applicable when using the replace function in VBA. I have heard of Regex objects, but that looks a little complex for such an 'easy' task.

E.g.

Please Login or Register  to view this content.

Above illustrates what I am trying to achieve

Originally Posted by esbencito

Hi all,
Above illustrates what I am trying to achieve

No, just show us the result that you want.

Fair enough...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks! That works very well! Still trying to understand the pattern references that you used, but overall, RegEx seems to be quite powerful and a good solution here.