Hi Nikhil
If you are using find and replace option, make sure that the word you want
to "find" does not contain any part of any of the sheet names. In case it
contains (if it is damaging the formulae), change the sheet names before
"replacing" the formulae.
You can restore the sheet names afterw
Dear Nikhil,
if it is the same formula u used for 3000 times then copy the complete
formula then press CTRL+H paste in 'FIND WHAT' column then go to 'Replace
with' column then paste again and change "M" to "A" and press Replace All.
it will replace all you want.
Try it
Regards
Vir
2009/11/25 d
OK... so what did you use to replace it?
did you use find/replace a with m ??
If so, it will try to find ALL cases of the letter "a" and replace it
with "m".
Probably what you're seeing is that you've changed the letter 'a' in a
sheet name
or workbook name that is used in a formula, and it wants to
thanks for the reply
I am using If(Value>0,"a",0). And Now i want to change "a" with say
"m". is it possible. The formula is used for 3000 times on my single
sheet. When i tried it offered me to save in anouther new sheet. which
i cannt do.
On Nov 24, 10:56 pm, RolfJ wrote:
> You should provid
You should provide a bit more detail. What's the formula? Which
characters do you need to change?
On Nov 24, 2:51 am, nikhil deshpande wrote:
> Dear all,
>
> I need to change characters used to show results in (IF ELSE ) formula.
>
> I tried ctrl F- replace. but it is disturbing mu sheet and aski
