I have 1315 rows in Excel. They are B2 through B1315

I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink. I don't want to have to do this one by one. Does anybody
know a way to do them all at the same time? Please simplify
instructions.

Thank you
Vince

if they don't have to be in column B

in C2
=Hyperlink(B2,b2)

then drag fill down

--
Regards,
Tom Ogilvy

" wrote:

I have 1315 rows in Excel. They are B2 through B1315

I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink. I don't want to have to do this one by one. Does anybody
know a way to do them all at the same time? Please simplify
instructions.

Thank you
Vince

Put something like this in C2 and drag down:

=hyperlink(b2,b2)
or
=hyperlink("http://" & b2, b2)


wrote:

I have 1315 rows in Excel. They are B2 through B1315

I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink. I don't want to have to do this one by one. Does anybody
know a way to do them all at the same time? Please simplify
instructions.

Thank you
Vince

--

Dave Peterson

If your weblinks are written correctly like www.google.co.uk you can change
them First make sure the auto correct for web links, check
toolsautocorrectauto format as you typecheck internet and network paths.
type in a web address in a cell like www.google.co.uk (should change to a
hyperlink), copy this cell and then select your row or column and paste
specialformat.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


" wrote:

I have 1315 rows in Excel. They are B2 through B1315

I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink. I don't want to have to do this one by one. Does anybody
know a way to do them all at the same time? Please simplify
instructions.

Thank you
Vince