I have a website (hyperlink) value in excel field. In another excel field I have a value to add to the end of the hyperlink which will change the page of the website it goes to.
For example: "https://pacs.xxxxxxxxxx.com/Viewer/app?page=ViewReport&details=
" is the website hyperlink value that will not change in field C1.
"G12345" are examples of the fields listed down the B column and changes.
I need the hyperlink website to stay static but the end of the hyperlink to change based on the value in the B column.
When I try a formula like =c1&b3 I get the correct hyperlink as https://pacs.xxxxxxxxxx.com/Viewer/app?page=ViewReport&details=0000.001
however if I copy the formula down the rows the hyperlink looks correct but it only launches the page to the first "0000.001" and not to 0000.005 even though the hyperlink shows 0000.005.
Is there a better way to do this?