maybe You will need only simple join of texts

Consider to attach some expamle workbook with dummy data.

example of join
  partURL ="http://someaddress.com?user="
  For Each cl in columns("A").specialcells(2)
    cl.offset(,1).value = partURL & cl
  next cl