I have 2 columns in a list that I want to use to create a single URL by concatenating both values.

i.e. column1 value is 'www.bbc.co.uk', and column2 value is 'news'.

I want column3 to be a hyperlink to 'www.bbc.co.uk/news'

Thanks in advance Colin

1 Answer 1


A calculated column =concatenate([column 1], "/", [column 2]) should do it.

  • Thanks very much - I had tried your suggestion previously but failed, I realised my error was column1 was a Hyperlink type - once I changed this to Single line of text, it worked. Many thanks again.
    – user27202
    May 29, 2014 at 6:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.