Using macros in custom table data

Wondering if it is possible to resolve macros inside a field of a custom table that is a rich test editor.
I see there is a button to insert a macro into the field, but when I view the data using a transformation is just shows the macro expression not the value it should resolve to.