Find number in parenthesis and replace with text and increasing number

Hi, I am making the footnotes and there are thousand of it. Could you please help to make macro to find increasing number in parenthesis and replace with text and increasing number? Please refer to attachment for detail. Thank you very much.

Hi there,

See if the following code gets you moving in the right direction:

Please Login or Register  to view this content.

The highlighted value may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Try
Output in Col.B

Please Login or Register  to view this content.

Hi All, thank you very much. Both codes work fine. This help me save a lot of time. Really thanks for your helps. ~~

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M