View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Convert list of URLs to Hyperlinks

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the column a
link in the sheet?