With VBA it is

Sub CopyMerged()
'A1, B1 & C1 are merged
Range("A1").Copy Range("E1")
End Sub

Seems to work for me.
Mike F

"Al Franz" wrote in message
...
Have seen other posts on this and seems odd their is no solution. Have a
column of cells where each cell is a few merged cells. Want to copy and
paste these merged cells contents to other cells that are not merged but
always get an error : "Can't change part of a merged cell".

Isn't there a way to cut and paste where the merged cells contents are
treated as a single cells contents? Certain SPECIAL PASTE features?