| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert text to hyperlink
i was given a list of sites to incorporate into a spreadsheet. the sites were
plain text, not set up as hyperlinks. the list is rather lengthy. is there an easy way to convert the text into working hyperlinks? I want to jump to the sites once you click on the link. example: napw.com retirementjobs.com clutchmagonline.com koreadirect.com africanmag.com latiplanet.com |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert text to hyperlink
I'd use an adjacent column:
=hyperlink("http://" & a1, a1) and drag down. (maybe hide that original column, too???) se7098 wrote: i was given a list of sites to incorporate into a spreadsheet. the sites were plain text, not set up as hyperlinks. the list is rather lengthy. is there an easy way to convert the text into working hyperlinks? I want to jump to the sites once you click on the link. example: napw.com retirementjobs.com clutchmagonline.com koreadirect.com africanmag.com latiplanet.com -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert text to hyperlink
Thanks Dave - perfecto!!!
"Dave Peterson" wrote: I'd use an adjacent column: =hyperlink("http://" & a1, a1) and drag down. (maybe hide that original column, too???) se7098 wrote: i was given a list of sites to incorporate into a spreadsheet. the sites were plain text, not set up as hyperlinks. the list is rather lengthy. is there an easy way to convert the text into working hyperlinks? I want to jump to the sites once you click on the link. example: napw.com retirementjobs.com clutchmagonline.com koreadirect.com africanmag.com latiplanet.com -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Inserted HTML text as Hyperlink | Excel Worksheet Functions | |||
| Convert hyperlink function into hyperlink | Excel Worksheet Functions | |||
| Convert Hyperlink into URL | Excel Discussion (Misc queries) | |||
| Convert Hyperlink to cell value automatically | Excel Worksheet Functions | |||
| How to convert a hyperlink to its target full-text URL | Excel Discussion (Misc queries) | |||
Linear Mode
