Merged cell paste NIGHTMARE

[amorrison2006]

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

 

[Guest]

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

 

[Peo Sjoblom]

If I were you I would remove the merged cells, all people that I know of
with good Excel knowledge always warn about using merged cells because
sooner or later you will have problems. For instance if you merge cells
A11 to get a header that looks good, you might as well select A11, then
do format>cells>alignment and select center across selection instead, then
type the header into A1, it will look the same with none of the drawbacks.
I can't tell you what to do since I NEVER use merged cells and if I receive
a workbook with merged cells I remove the merge