View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dale Dale is offline
external usenet poster
 
Posts: 92
Default pulling a list of hyperlinks from a worksheet

I have a worksheet with over 800 cells. Each cell displays a churches
website url. I need to display the actual hyperlink http://www.whatever.com
not the Link name.
example First Baptist Church Nashville. I need the hyperlink
http://fbcnashville.org. displayed in the next cell.