I have a column that I have a formula in. I want to take the results of the
formula and copy it into a new column so I can copy it as text. Thanks.

There is a little trick:

Say A1 has
=1+1

first format B1 as Text
second select A1 and do a copy
third select B1 and paste/special as value

B1 will contain 2 as a piece of text.
--
Gary's Student


"nodotdak" wrote:

I have a column that I have a formula in. I want to take the results of the
formula and copy it into a new column so I can copy it as text. Thanks.

thanks. it worked.

"Gary''s Student" wrote:

There is a little trick:

Say A1 has
=1+1

first format B1 as Text
second select A1 and do a copy
third select B1 and paste/special as value

B1 will contain 2 as a piece of text.
--
Gary's Student


"nodotdak" wrote:

I have a column that I have a formula in. I want to take the results of the
formula and copy it into a new column so I can copy it as text. Thanks.

EditPaste SpecialValues will give you the result of the formula in the
cell you copied rather than the pasting the formula itself.

Alternatively you can rt-click to paste & choose Paste Special from the
contextual menu or simply Paste, then use the Paste Options button to select
Values Only.

If you want the pasted content to actually be treated as text you will still
have to reformat the cell using FormatCells - Text.

HTH |:)
Bob Jones
[MVP] Office:Mac



On 11/22/06 10:59 AM, in article
, "nodotdak"
wrote:

I have a column that I have a formula in. I want to take the results of the
formula and copy it into a new column so I can copy it as text. Thanks.