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.

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.

EXCEL 2007

Assuming that your, "text formula in one worksheet" is in Book1 cell D4.

Go to Book2 cell D4 (or any cell of your choice) type in:-

=[Book1]Sheet1!$D$4

Book2 cell D4 will now be populated with, "the resulting text into another
worksheet".

If my comments have helped please hit Yes.

Thanks.

Step 1: place the cursor where you have the text of three cells formulae
step 2: copy the cell
step 3: place the cursor in other workbook where you want to paste it
step 4: right click and choose paste special
step 5: choose Values

all the best

But that results in a linking formula.

OP wanted values only.

Why not paste specialvalues?


Gord Dibben MS Excel MVP




On Thu, 6 May 2010 02:50:07 -0700, trip_to_tokyo
wrote:

EXCEL 2007

Assuming that your, "text formula in one worksheet" is in Book1 cell D4.

Go to Book2 cell D4 (or any cell of your choice) type in:-

=[Book1]Sheet1!$D$4

Book2 cell D4 will now be populated with, "the resulting text into another
worksheet".

If my comments have helped please hit Yes.

Thanks.