converting results from formula to text in a new column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nodotdak - 22 Nov 2006 15:59 GMT

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.

Reply to this Message

Gary''s Student - 22 Nov 2006 16:37 GMT

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.

Signature

Gary's Student

> 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.

Reply to this Message

nodotdak - 22 Nov 2006 16:47 GMT

thanks. it worked.

> There is a little trick:
>
[quoted text clipped - 9 lines]
> > 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.

Reply to this Message

CyberTaz - 22 Nov 2006 16:48 GMT

Edit>Paste Special>Values 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 Format>Cells - Text.

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

On 11/22/06 10:59 AM, in article
F281C446-7E6E-435B-8FC9-63ED801C0959@microsoft.com, "nodotdak"

> 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.

Reply to this Message