Lets say you have a column of "lazy" hyperlinks (don't respond to clicking)
in column A from A1 thru A100.

In B1 enter:
=HYPERLINK(A1)
and copy down. This will make a nice clickable list.
--
Gary''s Student - gsnu200720


"Terry Pinnell" wrote:

I suspect I'm making heavy weather of this, so would appreciate advice
please.

I have a set of standard URLs in my text editor, like
http://www.xyz.com
http://www.abc.com/123.htm
etc

I paste them into a new Excel 2000 column. But how can I quickly get
them all to become proper links, so that a click will open that
address in my browser please?

So far, the only way I can do it is by using Insert Hyperlink
(Ctrl+k) on each cell, and then copy/pasting the Text to Display into
the address box. Tedious with a large number to do.

I though I'd solved it by doing the first one that way and then using
the Format Painter on all the others. That turned them all promisingly
blue and underlined - but they had not received the magic clickability
attribute!

Failing any clever method, I suppose a repetitive macro might be the
way to go, if I can remember how to make them ;-)

--
Terry, West Sussex, UK