Use Ctrl + C to copy the data and then, to paste, go to Edit - Paste Special
and select 'Values'
--
tia

Jock


" wrote:

Hi

I hope someone can help

I am trying to paste cells as values - The cells are merged and and
underneath the cells that have been merged contain formulas

All I want is the top value - the one I can see to be pasted into a
new column as one value.

Does anyone know how to do this?

I'd appreciate your help with this,

Thanks

Andrea