Excel 2010 - Hyperlink Text Only & Not Entire Cell

I'm not sure.. I just wrote this, but it acts the same as adding a hyper reference (although you can still select the whitespace of a cell (after the text has finished) and it won't follow the link)

=CONCATENATE("This is your ", HYPERLINK("http://www.google.com","Google"), " link")

Just as a FYI, you can hold ALT key and click on a cell without it opening the URI


really, if you have wrap text turned on, the whole cell will act as a hyperlink. if you have wrap text turned off, only text will act as a hyperlink.


I got over this by turning off the "wrap text" from the cell formatting.