Excel Hyperlink Concatenation Help?

Question

I have an Excel sheet which is a list of people, and each person has their own web page on a certain website.

For example, if the website hyperlink was "http://bbc.co.uk" I want to be able to concatenate pages the equivalent of "\news"," \sport", "\weather", etc.

I have used the equivalent of:   =CONCATENATE("http://bbc.co.uk", C3)  where C3,C4, etc. contains a different page text string (e.g."/news", etc.) on a per row basis.

However, while the concatenation looks correct on the spreadsheet entry if you click on it, it gives incorrect results (e.g. link of first column entry or of the row below).

Any suggests or alternate methods of creating a variable string hyperlink ?

Note: I get the same bad results with Office 2016 on Windows 10, and Office 365 on my iPad pro.

Answer 1

You will have to concatenate like this

=HYPERLINK("http://bbc.co.uk"&C3)

=HYPERLINK("http://bbc.co.uk"&C3,"BBC News Page")