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