Making hyperlinks to a whole list of urls in excel

Hi,

I am new to excel ... I would highly appreciate if some one can help me with this problem... I have an excel sheet with a list of almost 2000 urls in one column (see below) But these are not click able ... Can some one tell me a simple way I can make all of them click able... so that once clicked it takes me directly to the site... Your help will be highly appreciated .. Thanks in advance.

AbtElectronics.com
AbundantEarth.com
AcademicSuperstore.com
AcademyLaw.com
AccessoryTown.com
AccessRespiratorySupply.com
AccorHotels.com
AccountNow.net
ACDSystems.com
AceHardware.com
AceMart.com
ACFactoryOutlet.com
AcLens.com
ACOP.com
AcornOnline.com
Acronis.com
ActivaSports.com
ACupOfIdeas.com
Adagio.com
ADASA.com
Adidas.com
AdirondackChairs.com
Adobe.com
ADT.com

Originally Posted by dominicb

Good afternoon max11

...and welcome to the forum!!

Lets say that your list starts in A1 and you want to put your hyperlinks in A2. Put this formula in B1 and copy it down :

=HYPERLINK("http://www." & A1,A1)

HTH

DominicB

Hey Dominic thanks for that Quick response... Much Appreciated!

Amazing works like a charm Thanks and God Bless!!