converting results from formula to text in a new column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
thanks. it worked.

Gary''s Student said:
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.
Click to expand...
 
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
 
Back
Top