Copy and paste data from merged cell

[neeraj2050]

Greetings!!

While copy any merged cell, if data is get pasted into other cell(which is not merged cell) then it overwrites other cells as well.

Is there any way to get rid of the same

Regards
Neeraj Kumar Agarwal

 

[bobhc]

Never use merged cells, I do not know how many cells are merged but you are taking multiple cell data and trying to get it into one cell, old saying...Two into one will not go.

Try this and stay away from merged cells. If you paste your selection, you'll notice a small blue icon at the bottom left of the pasted range. Click on it and select the third icon "Formulas & Number Formats":


.

 

[vletm]

@neeraj2050
If You use copy & paste then test this way:
Sample below: Merged (3 cells) cells with values 1,2,3 and single cell.

Activate cell and 'copy' that merged cell as 'normally'
Activate 'wanted single cell' -> go to formula bar -> paste

 

[neeraj2050]

Thanks to all for their support!!