Clearing formulations

[Sue]

How do i remove a formulation from a cell leaving the result?
I did copy, paste, then value but i need to copy down a column to do the
same thing to all the cells.
When i dragged down the column it just copied the first symbol instead of
doing each individually.
How can i get it to change each cell individually?

 

[David Biddulph]

Copy the column, *then* Edit/ Paste Special/ Values.

 

[Dennis]

Highlight all the cells in the column and then do copy - paste special - values