Hyperlink problem

=HYPERLINK(“https://cactus.nci.nih.gov/chemical/structure/”&C2&”/smiles”) does not work.

the website https://cactus.nci.nih.gov/chemical/structure/var/smiles where var is a string from cell C2 ex. 2042-14-0, the website returns a text called smiles

Thus https://cactus.nci.nih.gov/chemical/structure/2042-14-0/smiles returns the smiles string: Cc1ccc(O)cc1[N+]([O-])=O

i need the smioles string for a given var

Office 365

By: George Inglessis

Leave a Reply

Your email address will not be published. Required fields are marked *