Hyperlink mid string

[BanginMyHeadOnMyDesk]

I suspect I already know the answer to this, but just for the sake of due diligence could anyone advise if it's possible (or not) to embed a hyperlink mid string in a cell using the HYPERLINK function?

So the cell contents look something like "Lots of text here ThisIsAHyperlink and more text here".

Thanks.

B

[xlnitwit]

Hi,

No you can't do that in Excel. The hyperlink is for the whole cell.

[BanginMyHeadOnMyDesk]

Thought so, but better to check than to assume.

Many thanks for the quick response.

B