I have often found that xl will oftenautomatically convert to a hyperlink
with a couple of clicks.
toolsoptionsautocorrectcorrect as you type
or you could just have the text with a right click or double click event
tied to a follow hyperlink.
--
Don Guillett
SalesAid Software

"Terry Pinnell" wrote in message
...
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