Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks embedded in text
Can Excel (any version) be made to recognize/activate hyperlinks which
are embedded in other text in a cell? For axemple, entering "http://www.a.com" by itself in a cell makes Excel 2000 activate it as a hyperlink. But entering "Some text http://www.a.com more text" does not activate the embedded hyperlink. Can this be done (without scripting if possible)? |
#2
|
|||
|
|||
Rick wrote:
But entering "Some text http://www.a.com more text" does not activate the embedded hyperlink. Can this be done (without scripting if possible)? No. You could enter a formula =HYPERLINK("http://www.a.com","Some text http://www.a.com more text") Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Thanks. That turns the whole cell into a single hyperlink, right? I was
hoping to be able to have multiple hyperlinks in a single cell, embedded within a paragraph of text. Actually, what I need is to import existing text with embedded hyperlinks -- without hand-editing it if possible. I tried it in Word as well. Strangely, Word recognizes and activates multiple hyperlinks in a paragraph if you type the text manually, but if you copy/paste it or import it the hyperlinks are not recognized. |
#4
|
|||
|
|||
Rick wrote:
That turns the whole cell into a single hyperlink, right? I was hoping to be able to have multiple hyperlinks in a single cell, embedded within a paragraph of text. Excel does not have that ability. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Creating multiple hyperlinks from a column where the text in the . | Excel Worksheet Functions | |||
Creating multiple hyperlinks from a column where the text in the . | Excel Worksheet Functions |