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