add specific character in existing cell
 

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

add specific character in existing cell
 

= "=" &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