Cheers both.
I exported the xml and got them a different way, because ain't nobody got time for macros no more.
Editing the XML also allows you do tricky stuff with URLs that you can't do inside Excel. I think it's possible to have two links in a single cell, for example. Not to say you should.
@NotThamesWater started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Cheers both.
I exported the xml and got them a different way, because ain't nobody got time for macros no more.