Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract text from hyperlink
I have an Excel sheet that contains a column of cells that are hyperlinks.
Is there a way to extract the text of the hyperlink? For example, the cell contains a company, (Microsoft) that is hyperlinked to http://www.microsoft.com. I would like to extract the http://www.microsoft.com and put in a cell. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract text from hyperlink
Dim hlnk as Hyperlink
for each cell in Range("C1:C50") for each hlnk in cell.hyperlinks cell.offset(0,1).Value = hlnk.Address Next Next -- Regards, Tom Ogilvy "JP" wrote in message ... I have an Excel sheet that contains a column of cells that are hyperlinks. Is there a way to extract the text of the hyperlink? For example, the cell contains a company, (Microsoft) that is hyperlinked to http://www.microsoft.com. I would like to extract the http://www.microsoft.com and put in a cell. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract text from hyperlink
thanks!
"Tom Ogilvy" wrote: Dim hlnk as Hyperlink for each cell in Range("C1:C50") for each hlnk in cell.hyperlinks cell.offset(0,1).Value = hlnk.Address Next Next -- Regards, Tom Ogilvy "JP" wrote in message ... I have an Excel sheet that contains a column of cells that are hyperlinks. Is there a way to extract the text of the hyperlink? For example, the cell contains a company, (Microsoft) that is hyperlinked to http://www.microsoft.com. I would like to extract the http://www.microsoft.com and put in a cell. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula or code to extract hyperlink from displayed text | Excel Discussion (Misc queries) | |||
Need to extract hyperlink | Excel Programming | |||
How do I extract hyperlink as text from an array of hyperlinks? | Excel Worksheet Functions | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) | |||
Extract Hyperlink | Excel Programming |