hyperlink advice

[JCY]

I'm looking for an easy way around having to put quotation
marks around every hyperlink cell, I have many hundreds to
do.

Is there a way to format the column to automatically treat
and make usable a web address? I'm hoping to merely paste
the links and have it automatically format the cells to
jump.

Using Format-style-hyperlink only changes the appearance
and you can't jump to the site. Thanks

 

[Frank Kabel]

Hi
see your other post