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

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment utiliser Live Photos ?