Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would use another column and fill it with formulas:
=hyperlink(a1) or =hyperlink("http://" & a1) Depending on what the links look like. Andy Hendry wrote: -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Dave,
Can you elaborate on this? I'm a novice user and am having the same issue. Many thanks! Whyvon "Dave Peterson" wrote: I would use another column and fill it with formulas: =hyperlink(a1) or =hyperlink("http://" & a1) Depending on what the links look like. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you have
www.microsoft.com in A1, then put this in B1 =hyperlink("http://" & a1) You'll end up with a hyperlink in B1 that points at the site in A1. Why Von wrote: Hi Dave, Can you elaborate on this? I'm a novice user and am having the same issue. Many thanks! Whyvon "Dave Peterson" wrote: I would use another column and fill it with formulas: =hyperlink(a1) or =hyperlink("http://" & a1) Depending on what the links look like. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
search column, hyperlink, offset, substitute, match (omg) | Excel Discussion (Misc queries) | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
using the same function to convert a column of numbers | Excel Worksheet Functions |