I'd like to automatically create the content of a cell, based on the value of another cell.For instance:Cell content: 1337Cell content 2, automatically created: http://www.superuser.com/1337Which 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'. 
Appending the content of one cell to another cell
google spreadsheets;google forms