Converting_between_grams_(g)_and_moles

With a worksheet displayed, select a column in the Columns tab that contains units in grams (g) or moles (mol) and press Units Builder.

In the Units Builder dialog, type mol in the New Units field if the values are in grams or (mass prefix)g if the values are in moles (mol).

In the Molecular weight field, type the molecular weight and press OK.

The new unit is added to the column header and all values in the selected column are automatically converted.