URL links in Microsoft Excel

  Retired Hurt 15:21 21 Feb 05

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 05

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 05

Many thanks all done

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

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch Series 2 review | Apple Watch 2 review: New Apple Watch is faster, brighter,…