View Single Post
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

Assuming you want to show only these formulas and not all formulas on the
worksheet, I would first highlight this column of formulas, then use
Edit/Replace to replace, say, the <equal sign with <space<equal sign. This
makes them text. Then copy that text into the column to the right (Edit/Copy,
then Edit/Paste). Then use Edit/Replace again on the first column to replace
<space<equal sign with just <equal sign.

On Sat, 1 Oct 2005 15:59:01 -0700, "cradino"
wrote:

How can I make excel show in one column the fórmulas used in the previous
column. Example
1 =LIN()
2 =LIN()
3 =LIN()
4 =LIN()