freezing answers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
hi,
Try Edit>paste special> values. that will turn the formula
into hard data.
Regards
Frank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Can I freeze 3 different columns? 10
Does anyone have aformula for Weeks Supply? 1
Time sheet template military hours problem 6
A Formula required - please! 2
SUMIF: How to add some cells and ignore other cells in a row 2
Calculate hours, past midnight etc 4
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top