Convert Formula Result to Static Text

[MYGS]

Hi Guys,

I've searched high and low but can't seem to locate a solution, so here I am.

How can you dynamically convert a column containing formula results to static text?

Obviously it's easy to select the column and manually past values only, but how would you set this up for Excel to do it manually, ie. copy results to a new column ready for editing?

Thanks...