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.