I have a column of cells in a Google Spreadsheet with values such as:
37683 36583 38637 32391
What I would like to do is generate a hyperlink for each cell like:
...where xxxxx is the value of the cell. I know the format of a hyperlink in a Google spreadsheet and could do the job manually, I'm just wondering if I can generate these using a simple find/replace, or whether it will need scripting.
The new hyperlink can either go into the original cell, or a new cell can be created.