Hi Shani,
see http://www.mvps.org/dmcritchie/excel...perlinkaddress

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Shani" wrote in message oups.com...
In column A there a bunch of cells
I want to extract all the hyperlinks associated with the cells in
column A into Column B

for example
A1=axyfsk hyperlink=http://www.fasdfasdfasfsdfafd.com
I want B1=hyperlink=http://www.fasdfasdfasfsdfafd.com