hyperlink formatting

[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
not really sure what values you have in your column. Could you post an
example?.

 

[JCY]

Thanks for relying - I'm actually trying to activate
columns at a time

What I'm doing is exporting fields from my ACT! contact
managent program to excel, (easier for my boss). When the
web site field exports to a column, none of the links will
work without my having to go to each cell and add
parenthesis to each web address.

exports this
a b
Column
D'angelo's http://www.dangelos.com

I must change to this for the link to work
D'angelo's "http://www.dangelos.com"

 

[Dave Peterson]

I've never seen surrounding a link with double quotes make it a link.

But I have seen a worksheet formula make the job easier:

=hyperlink("http://" & b2, "Click me!")

And drag down column C.

 

[JCY]

Dave - Did the trick thanks

-----Original Message-----
I've never seen surrounding a link with double quotes make it a link.

But I have seen a worksheet formula make the job easier:

=hyperlink("http://" & b2, "Click me!")

And drag down column C.


--

Dave Peterson
(e-mail address removed)
.