Hyperlink a word
 

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks

Hyperlink a word
 

Im not 100% sure this can not be done but one thing you can do is format the
current hyperlink to look like that word is hyperlinked. So hilight any words
you don't want linked and change the font and underline properties to normal
text.

Not sure if this fits your needs though

"James" wrote:

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks

Hyperlink a word
 

hi, not sure that this is what looking for, but does search down a document
for next occurance of "dn", and jumps to it. it's kind of long, but it
works.

circular errors may occur if copy-paste line with this formula, just have to
paste a copy back over it to reset values; here, this was in row 690.

=HYPERLINK(IF(ISNA(INDEX(ROW(OFFSET($AX690:$AX$207 8,1,0))-ROW(OFFSET($AX690,1,0)),MATCH(TRUE,OFFSET($AX690:$ AX$2078,1,0)="dn",0))),"","#"&CELL("address",OFFSE T(INDIRECT(SUBSTITUTE(SUBSTITUTE(CELL("address",$A 690),"$",""),ROW(),"")&INDEX(ROW(OFFSET($AX690:$AX $2078,1,0)),MATCH(TRUE,OFFSET($AX690:$AX$2078,1,0) ="dn",0))),$AB$3,1))),"dn")

$AB$3 was utility made for size of page-header..
$AA$3-CELL("row",$A$20))-2

$AA$3
=$AU$7+$AX$7 (hand entry number of rows showing minus (plus) rows hidden
in header, that are utility rows..


"James" wrote:

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks

Hyperlink a word
 

ps, originated from indocument hyperlink, that works to exact same spot every
time

=HYPERLINK("#"&CELL("address",OFFSET($A$690,IF(ROW ($A$690)(ROW($A690)-$AB$3/3),$AB$3,-1),1)),"7")

"James" wrote:

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks

Hyperlink a word
 

Hyperlinks (=hyperlink() or insert|hyperlink) will apply to the whole cell.

But you could cheat.

Add a rectangle over the word in the cell. Hide its borders. Assign a
hyperlink to that hidden rectangle.

If you enter the string in the cell as text (not a formula), you could even
format the characters under the rectangle so that it looks like a hyerlink
(blue, underlined).

But if you enter a formula (or numbers), then you can't do this kind of
character by character formatting.

James wrote:

I know how to link a cell to a web page or another document, but I cannot
figure out how to make the link apply to just a word in the cell.

I have a cell with multiple words in it, and would only like to see one of
those words have the hyperlink associated with it. Can this be done??

Thanks

--

Dave Peterson