=hyperlink function (Google sheets): how to extract the result

JavaScript
1

I have several names in column A on a spreadsheet which I turn into a clickable hyperlink called “Line is produced here” using this function:

=HYPERLINK(CONCATENATE(“http://www.anysite.co.uk/?s=“,SUBSTITUTE(A1,” “,”+”),“&post_type=product”),“Link is produced here”)

For example, if cell A1 contains Nottingham City Centre, the function correctly allows a url to be launched in a new window as: http://www.amysite.co.uk/?s=Nottingham+City+Centre&post_type=product

I want to be able to extract this url and put it into it’s own cell on a Google sheet.

Is there a script that can do this please?

Best wishes.

2

I don’t believe there’s a JavaScript API for creating sheets in Google Drive but you can look here https://developers.google.com/google-apps/spreadsheets/

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.