Merge

[Guest]

I HAVE A MERGED CELL AND I WANT TO UNMERGED IT AND TO COPY THE DATA THAT WAS
IN THE MERGED CELL TO THE CELLS THAT HAVE BEEN UNMERGED(I HOPE THAT YOU
UNDERSTAND ME)


AND THANK YOU FOR YOUR TIME

 

[David Biddulph]

Firstly, please find the Caps Lock key and stop SHOUTING.

Secondly, select the cells, then Format/ Cells/ Alignment:
Unselect "Merge cells".

Having unmerged the cells, you can copy what you want where you want it.