1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded education professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Excel Query

Discussion in 'Computing and ICT' started by resources4drama, Dec 1, 2011.

  1. resources4drama

    resources4drama New commenter

    Hoping someone might have a solution to this :
    I have a spreadsheet with two columns.
    Column A has a descriptive list of websites in plain text
    Column B has the address of the corresponding websites as hyperlinks.
    So this page would be displayed in column A as TES ICT Forum
    and in Column B clickable as https://community.tes.co.uk/forums/AddPost.aspx?ForumID=22
    Is there a quick way to make all the text entries in Column A clickable with the adjacent entry in column B? Or do I have to go through inserting hyperlinks one by one by copy and pasting (I've got hundreds to do!)
    Thanks in anticipation.

  2. resources4drama

    resources4drama New commenter

    Absolutely, stunningly brilliant solution which has saved me hours.
    Gor bless you, guvnor.

Share This Page