how do i copy the result of a formula into another worksheet as te

[RaeRae]

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.

 

[Stefi]

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:

 

[trip_to_tokyo]

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.

 

[Gord Dibben]

But that results in a linking formula.

OP wanted values only.

Why not paste special>values?


Gord Dibben MS Excel MVP