Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

mic j

macrumors 68030
Original poster
Mar 15, 2012
2,663
156
I have a spreadsheet with cells that have hyperlinks to files stored on my MBP. I need to either display (or extract) the underlying hyperlinks so that I can create a separate column displaying the hyperlink address (not the friendly view). I have seen you can do this with VBA on PC versions of Excel but, at least per my understanding, the Mac version does not provide VBA capability.

Can anyone suggest how I might go about doing the above? :confused:
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.