Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied?

Any help would be appreciated.

Thank You.