I'd like to automatically create the content of a cell, based on the value of another cell.
Cell content: 1337
Cell content 2, automatically created: http://www.superuser.com/1337
Which means, URL needs to be added. It can be retrieved from another cell, not that important, as long as it gets automatically created. Otherwise I can just type it in myself.
Why: for work, I am creating a Google Form, which gets a value. The '1337'. In the answer sheet afterwards, it should be listed as the 'http://www.superuser.com/1337'.