AutoCorrect
 

Hi...
i have a problem that i want to share it with u people. it is about
AutoCorrect.
Suppose when i write " Potat" so it change to " Potato"
but when i use it like it. where cell a2=potato
=left(a2,len(a2)-1)
so i get the result "Potat" which don't change automatically to "Potato"
i need the help................. plz
Email me plz at :-

Autocorrect will only work on typed in text entries, not formula

--
Regards,

Peo Sjoblom


"reneabesmer" wrote in message
...
Hi...
i have a problem that i want to share it with u people. it is about
AutoCorrect.
Suppose when i write " Potat" so it change to " Potato"
but when i use it like it. where cell a2=potato
=left(a2,len(a2)-1)
so i get the result "Potat" which don't change automatically to "Potato"
i need the help................. plz
Email me plz at :-