| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert column of about 900 web addressesinto hyperlink
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert column of about 900 web addressesinto hyperlink
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
|
|||
|
|||
|
How do I convert column of about 900 web addressesinto hyperl
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
|
|||
|
|||
|
How do I convert column of about 900 web addressesinto hyperl
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
