Excel - exporting hyperlinks 1

[XgrinderX]

Hello!

I have an Excel spread sheeet with about 300 rows in it. Each row has a column that includes a hyperlink. I want to be able to copy JUST THE HYPERLINK into a separate cell.

I know I can do this by going row by row and right clicking, choosing Hyperlink, then Copy Hyperlink, and then pasting it in the cell I want, but that is very tedious work for 300 rows.

Does anyone know of a way to do a mass copy of the hyperlink only so that I have one cell (the original cell) with the hyperlink description and then a new cell with the hyperlink URL in it?

Thanks,

-Greg

 

[Dreamboat]

Here you go, Greg:

http://www.microsoftexceltraining.com/VBA/HyperlinkAddress.htm

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[XgrinderX]

OH MAN! That's awesome, thanks a LOT! I have never ever messed with creating my own function before....this looks like something I need to lear a little more about.

THANKS AGAIN, that worked like a charm!!

-Greg

 

[Dreamboat]

You bet, Greg. I knew it was around somewhere...

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX