Batch edit different hyperlinks

Hi I hope someone can post a reply to this question. I'm sure it's dead simple for an expert.

I have a list of 10000+ entries. the last field in each entry is a hyperlink and I need to add a sequence of numbers to the end of each one, for example /371008521318. The hyperlinks aren't the same so I can't just find and replace each hyperlink. I need to add to the end.

Thanks in advance,

Marc

more than likely, you can edit links with the properties that they come with. take a look at the attached image. this shows you a couple of the properties that come with it. textToDisplay are the words you see on the screen that are underlined and in the color blue. address is the actual location the link points to. do you know what an index is? in the image, the index 0 is being used. that's the first created hyperlink in the workbook, regardless of where it's at.