I have a spreadsheet which contains over 1,000 hyperlinks to a website.
Many don't work because they are missing two semi-colons.

Is there a quick way to check which ones have the missing semi-colons and to
insert them. There are two places in the hyperlink where they should
occur - always before &version and always at the end of the hyper link.

Any pointers in the right direction would be greatly appreciated.

Rusty