= "=" &SUBSTITUTE(A1,"x","*") then copy down and pastespecial-values. Then,
to force the calculations, Replace = with =
--
Regards
Dave Hawley
www.ozgrid.com
"Rajiv" wrote in message
...
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