select the range
copy
edit-paste special-values



"Kim" wrote in message
...
Is there a way to convert the data returned from a formula to text and
remove
the formula? For example, I have a cell containing this formula:
=IF('Current Registrants'!F5="yes", 'Current Registrants'!J5, 0). After
the
value has been returned, I would like to convert that cell to the return
value & get rid of the formula. Is this possible? Thank you for your
suggestions.