how do i copy the result of a formula into another worksheet as te
You have two options:
1. Refer to the first worksheet: if the concatenation formula is in A1 of
sheet1 then enter =Sheet1!A1 in the cell in sheet 2 where you want to place
the result.
2. Copy Sheet1!A1, PasteSpecial/Values into the required cell in sheet 2.
--
Regards!
Stefi
€˛RaeRae€¯ ezt Ć*rta:
I have a text formula in one worksheet, adding the text of three cells
together into one cell. i would then like to copy the resulting text into
another worksheet and not the formula. Thank you for your help.
|