copy data without formulae

[mani_singh]

hi everyone again - i need to copy and paste data from one cell into another without moving, altering or copying the formulae in the original cell

i.e. copy just the data without the formulae

thanks

 

[ADAMC]

Right click and copy the cell.

Click in your destination cell
Choose Edit > Paste special > choose 'values'

 

[starl]

Duplicate: http://www.mrexcel.com/board2/viewtopic.php?t=285112