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.

Dave
Wed Oct 08 07:08:46 CDT 2008

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

Cajeto63
Wed Oct 08 07:48:06 CDT 2008

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
>

Andy
Wed Oct 08 08:22:01 CDT 2008

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" <Cajeto63@discussions.microsoft.com> wrote in message
news:5E9F8043-DFEF-4764-A03E-CAEE1B911E97@microsoft.com...
> 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.
>
>
>

DataHog
Wed Oct 08 12:29:01 CDT 2008

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.
>
>
>