hyperlink on part of a text contained in a cell
 

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.
--


Regards, Cajeto 63.

hyperlink on part of a text contained in a cell
 

Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.

Cajeto 63 wrote:

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.
--

Regards, Cajeto 63.

--

Dave Peterson

hyperlink on part of a text contained in a cell
 

Thank you Dave for that fast and easy trick that will work fine.

--


Regards, Cajeto 63.





"Dave Peterson" wrote:

Excel doesn't support this kind of thing.

But you could cheat.

You could add a rectangle from the Drawing toolbar (hide the borders!) and
assign a hyperlink to that rectangle.

Cajeto 63 wrote:

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.
--

Regards, Cajeto 63.

--

Dave Peterson

hyperlink on part of a text contained in a cell
 

Hi,

A possible appearance work around would be,
Apply hyperlink to the whole cell. Then edit the cells font attributes.
Remove blue colour and underline. Now edit the cell content and select only
the word Google.
Reapply Blue font with underline.

The whole cell will act as hyperlink but only Google will look like
hyperlink.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Cajeto 63" wrote in message
...
Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google
only.

Thank you.
--


Regards, Cajeto 63.

hyperlink on part of a text contained in a cell
 

Try this routine:

Sub AddCellHyperlink()
' Select cell on the worksheet to place the hyperlink
'
cellcontents = InputBox("Enter Cell Display", "Hyperlink Cell Display", _
Default:=ActiveCell.Value)
If cellcontents = "" Then Exit Sub
ActiveCell.Formula = cellcontents

webaddress = InputBox("Enter Web Address:" & Chr(13) & _
"Example: http://www.google.com", "Hyperlink Address", _
Default:="http://www.google.com/")
If webaddress = "" Then Exit Sub

With Worksheets(1)
.Hyperlinks.Add ActiveCell, webaddress
End With
End Sub

J Knowles

"Cajeto 63" wrote:

Hello,

I would like to know how I can apply a hyperlink to only a part of a text
that is contain into a cell.

Example: cell contains "If you doubt it just Google it!"
where there would be a link to the "Google" website on the word Google only.

Thank you.
--


Regards, Cajeto 63.