dearomatize entire column of structures

User 3afdb4ab90

26-01-2010 23:32:56

I have successfully used JCStandardizeStructure to display one dearomatized structure,

=JCStandardizeStructure(A2, "dearomatize")

but I would like to apply it to an entire column of structures.   How can I do this?

I'm using JChem for Excel 1.1.3 and Excel 2007.

ChemAxon 0e37943a96

27-01-2010 07:27:41


sure. You have to simply fill the formula to the other cells. Excel 2007 offers several ways to do that:

It does not mention that in excel 2007 you can also double click on the bottom right corner of the cell (on the small black square), and it will automatically fill it for all rows.

Best regards,