Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can you add an HTML URL to a cell with normal text?

I have a cell with normal text, but want to add a URL, but I don't want the whole cell to be the URL.

i.e.

Please go to this link: www.123.com

When I type that into a cell, it doesn;t let me put the hyperlink in.

So the user would double click in the cell, then click the hyperlink.

Is there any easy way to do this, without using macros?

share|improve this question
    
How do you mean a friendly_name? –  Kevdog777 May 21 '13 at 10:14
1  
A formula such as =HYPERLINK("http:\\www.cnn.com","Please go to this link") will only display the part after the comma (until clicked!) –  pnuts May 21 '13 at 10:29
    
Fantastic @pnuts (+1), that worked correctly. thanks :) - but it is also the same as right clicking the cell and selecting hyperlink, and doing it that way... without the use of formulas. –  Kevdog777 May 21 '13 at 10:39
    
Try doing many tens of thousands 'your' way, when you already have a list of addresses! –  pnuts May 24 '13 at 17:06

1 Answer 1

up vote 1 down vote accepted

You cannot have normal text and a hyperlink in the same cell. Either it will be entirely text or entirely a hyperlink.

Depending on the formatting of your sheet, you may be able to enter "Please go to this link:" in one cell, sizing the cell so that it is just big enough for the text, and in the cell on the right have the hyperlink to "www.123.com".

share|improve this answer
    
Thank you, I did think it was not possible. It was worth asking though. –  Kevdog777 May 21 '13 at 10:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.