Hyperlink display text maximum in Excel 2003

[Guest]

Every time I try to create a hyperlink of a cell (that contains a couple of
sentences worth of text), I seem to reach the maximum allowed characters for
the display text - and Excel cuts off the end of the paragraph. Hence, the
the hyperlink is created, but I loose half the content of the cell.
Any ideas?

 

[Dave Peterson]

It looks like that text to display can be 255 characters.

And the same thing holds for =hyperlink(link_location,Friendly_name)

Friendly_name can be up to 255 characters--and if you point at another cell that
contains a longer string, you'll get an error back.

Maybe you could put the hyperlink in one cell and the text in another.

Or even add a textbox from the Forms toolbar and then assign the hyperlink to
that textbox.

 

[Guest]

Thanks, I like the idea of just putting the text in one cell and the
hyperlink in a cell next to it.