Prev: External data properties
Next: Creating a list using the file names
From: Rajiv on 12 Apr 2010 02:08
i have put one text in cell A1 (i.e. 45x15), and i have more than 100 cell
like this cell. i want to add = (equal sing) in the left side of all cells.
pls help me on these formula.

thanx in advance

rajiv
From: ozgrid.com on 12 Apr 2010 03:00
= "=" &SUBSTITUTE(A1,"x","*") then copy down and pastespecial-values. Then,
to force the calculations, Replace = with =



--
Regards
Dave Hawley
www.ozgrid.com


"Rajiv" <Rajiv(a)discussions.microsoft.com> wrote in message
news:A1ADF43C-C579-48B4-A380-E13C99E27860(a)microsoft.com...
>i have put one text in cell A1 (i.e. 45x15), and i have more than 100 cell
> like this cell. i want to add = (equal sing) in the left side of all
> cells.
> pls help me on these formula.
>
> thanx in advance
>
> rajiv

 | 
Pages: 1
Prev: External data properties
Next: Creating a list using the file names