Export hyperlinks

Hello,

I need some help writing a script/macro for excel to take an entire column out of excel and edit it along the way.

In general I have many columns but only ONE needs to be exported.
The value in each of thease cells looks like this-
=HYPERLINK("The Plots\"&X5&"_TT_"&Y5&".png",X5)
but you only see whatever "X5" is because thats the text variable.


As you can see they could reference many other cells in this.

When I copy the column it just gives me the text (Whatever is after the ",")

In short I am looking for a script that will take a column starting from a certain row and spit out the actual file-system links IE:
=HYPERLINK("The Plots\"&X5&"_TT_"&Y5&".png",X5)
would become
The Plots\secondary\_TT_Inner.png

It can export to notepad or another excel column as text it really doesn't matter.



I really apreciate any help I can get on this I have been staring at my screen for hours trying to figure this out. I really do not not know any VB so that compounds the problem. I hope I was descriptive enough in this.

~Thanks again