Macro to replace * with /
Well here's a rather embarassing problem.
I sent out about a kazillion files for people to enter information in
and one of the columns has a =Cell*12 in it where cell is the cell
address over dozens of rows (e.g.
=aa10*12
=aa11*12
etc.
I thought it would be simple to do a record macro to replace the * with
a / but something that I thought would be trival has escaped me....
any help would be appreciated.
|