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.