| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink formula
Lets say A1 contains:
http://www.cnn.com In B1 enter: =HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200737 "Connie Martin" wrote: My spreadsheet of over 10,000 rows has a column with company internet homepage addresses in it. Is there a way to convert that whole column to hyperlinks in one shot? Connie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink formula
Thank you so much! That works. Connie
"Gary''s Student" wrote: Lets say A1 contains: http://www.cnn.com In B1 enter: =HYPERLINK(A1,A1) and copy down -- Gary''s Student - gsnu200737 "Connie Martin" wrote: My spreadsheet of over 10,000 rows has a column with company internet homepage addresses in it. Is there a way to convert that whole column to hyperlinks in one shot? Connie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what formula will get the url from a cell with a hyperlink? | Excel Worksheet Functions | |||
| Hyperlink Formula | Excel Discussion (Misc queries) | |||
| How to extract the url in a hyperlink using a formula | Excel Worksheet Functions | |||
| Hyperlink in nested formula not linking | Excel Discussion (Misc queries) | |||
| hyperlink formula | Excel Discussion (Misc queries) | |||
Linear Mode
