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

"(E-Mail Removed)" 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)


(E-Mail Removed) 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
tools>autocorrect>auto format as you type>check 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
special>format.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"(E-Mail Removed)" 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
>
>