add specific character in existing cell

  • Thread starter Thread starter Rajiv
  • Start date Start date
R

Rajiv

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
 
= "=" &SUBSTITUTE(A1,"x","*") then copy down and pastespecial-values. Then,
to force the calculations, Replace = with =
 
Back
Top