make partial text in a cell as hyperlink

hi,

I know how to make a cell into a hyperlink, is there a way to make partial text in a cell as hyperlink?  thx
mcrmgAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
No, it is not possible to add a hyperlink to only part of the cell content in Excel. It's all or nothing, I'm afraid.

Regards,
Rory
0
 
Naresh PatelTraderCommented:
Hi mcrmg,

Step 1 Right click on hyperlink cell & select edit hyperlink.
Step 2 very first option on popup box "Text To display". Enter what ever you want to display instead of whole URL.
Step 3 ok & Done.


Thanks
0
 
P WDCommented:
Rory - not true.  I just did itjockey's suggestion and it worked for me.  Basically, what you end up putting in the "Text to Display" window, is the only text that will show in that window, so make it meaningful.  And put the link that you want it to go to, in the Link window in the bottom of that dialog box.
0
 
Rory ArchibaldCommented:
That is not actually adding a hyperlink to part of the text. The whole text is still a hyperlink.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.