| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Hyperlink cell with Title
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging Hyperlink cell with Title
Hi,
Here's one way, depending on what you are trying to do. You can hyperlink the title. Just put your cursor in the title cell and choose Insert, Hyperlink and navigate as necessary. -- Thanks, Shane Devenshire "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Title in Cell? | Excel Discussion (Misc queries) | |||
| Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Show full path title in title bar? | New Users to Excel | |||
| Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
Linear Mode
