| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert list of URLs to Hyperlinks
I have sheet that contains a column of URLs that are NOT linked.
Is there a way I can automate the process and make every URL in the column a link in the sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert list of URLs to Hyperlinks
In B1:
=HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200829 "jabe813" wrote: I have sheet that contains a column of URLs that are NOT linked. Is there a way I can automate the process and make every URL in the column a link in the sheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert list of URLs to Hyperlinks
Novice at this...
The URL list is in column B. When I put =HYPERLINK(A1,A1) in B1, it changes the the URL that was displayed to a 0 "Gary''s Student" wrote: In B1: =HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200829 "jabe813" wrote: I have sheet that contains a column of URLs that are NOT linked. Is there a way I can automate the process and make every URL in the column a link in the sheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert list of URLs to Hyperlinks
If your hyperlink text is in column B, change the A1 to B1 in the formula.
-- David Biddulph "jabe813" wrote in message ... Novice at this... The URL list is in column B. When I put =HYPERLINK(A1,A1) in B1, it changes the the URL that was displayed to a 0 "Gary''s Student" wrote: In B1: =HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200829 "jabe813" wrote: I have sheet that contains a column of URLs that are NOT linked. Is there a way I can automate the process and make every URL in the column a link in the sheet? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert list of URLs to Hyperlinks
Thank you. I tried that as well.
Instead of displaying a 0 it displays "Address" Links to the right place but, I need to display the URL I am supposed to be putting this in the formula bar, correct? "David Biddulph" wrote: If your hyperlink text is in column B, change the A1 to B1 in the formula. -- David Biddulph "jabe813" wrote in message ... Novice at this... The URL list is in column B. When I put =HYPERLINK(A1,A1) in B1, it changes the the URL that was displayed to a 0 "Gary''s Student" wrote: In B1: =HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200829 "jabe813" wrote: I have sheet that contains a column of URLs that are NOT linked. Is there a way I can automate the process and make every URL in the column a link in the sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert web addresses into hyperlinks | Excel Discussion (Misc queries) | |||
| Convert Text to Hyperlinks | Excel Discussion (Misc queries) | |||
| Convert urls to links | Excel Discussion (Misc queries) | |||
| Macro to convert hyperlinks to text | Excel Worksheet Functions | |||
| activate column of URLs as hyperlinks | Excel Discussion (Misc queries) | |||
Hybrid Mode
