Show cell fórmula not value
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() |
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() |
If you can use a VBA solution, this function may help. Go to the VB Editor and
insert a standard module in your workbook. Paste the following code in the code pane on the right. Then on the worksheet, to get the formula in a cell, say K22, in another cell, say L22, you would use the formula =CellFormula(K22) Function CellFormula(Rng As Range) CellFormula = " " & Rng.Cells(1).Formula End Function On Sat, 01 Oct 2005 18:11:17 -0500, Myrna Larson wrote: 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() |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com