Combine cell content into an html code?

Hello everyone,

Taking advantage of csv files and importing into websites. Basically I have a html code in a cell which needs to pick out content from different cells in the same row. Is that possible?

<a href="/signup?name=A2&email=B2">Go</a>

So the A2 and B2 would be contents of their respective cells. Tried out a few things but kept getting errors.

Thanks!