URL links in Microsoft Excel

  Retired Hurt 15:21 21 Feb 2005

I want to create an Excel spreadsheet in which one column will contain URL links to websites.
In Word typing in such an address allows a double click to link to the chosen website.
In excel, hyperlinks do the same, but unlike word typed addresses do not automatically convert to links.Can I set up a column to treat the cell entries as hyperlinks without going through the rigmarole of typing each one separately,(there are nearly 100)as I can import a word list into Excel to avoid retyping. Any ideas/short cuts would be appreciated, as even cut'n paste is a lengthy task when dome one at a time.

  VoG II 15:22 21 Feb 2005

Yes. Say your website addresses are in column A, then in B1 enter the formula


and copy the formula down as far as needed.

  Retired Hurt 15:37 21 Feb 2005

Many thanks all done

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy S9 review

Explore Milton Glaser's iconic poster designs from the 1960s to present, including Bob Dylan, I…

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts