converting results from formula to text in a new column
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.
|