Thread: Merging Hyperlink cell with Title
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 Merging Hyperlink cell with Title
In C1 enter:

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


"mgbard" wrote:

Column A is a URL
Column B is the title of the page the URL points to.

How can I merge A & B so I have the title hyperlinked?
Reply With QuoteReply With Quote