freezing answers?

L

Little pete

using the below formula, =CONCATENATE(E3,D3,C3,F3,G3), works fine
However when copy and paste to a new sheet with only the answer the data
changes. is their away of freezing the data??

thanks for the help in advance
 
F

Frank Stone

hi,
Try Edit>paste special> values. that will turn the formula
into hard data.
Regards
Frank
 
Top