In article <
MPG.3ed58a399ed3f9a5989a66@news.eternal-september.org>, Philip Herlihy wrote...
In article <kcv33sFn7q3U1@mid.individual.net>, Andy Burns wrote...
Philip Herlihy wrote:
I have a friend whose surname is "Alway". As I'm putting together a mailing
list, I found myself typing that into Excel. It corrects it to "Always" -
What if you prefix with a single quote to make it a string literal e.g. 'Alway
Oddly, that seemed to work the first time I tried it, but subsequently didn't.
Can't explain that. The =LEFT() option did work, although it tried to correct
the string parameter (but accepted the edit).
Correction: it was resolute in autocorrecting the string parameter! But when I copied and pasted the value of =LEFT("Always", 5) the destination cell finally received the desired string. Doubtless if I ever tinker with that cell it'll do the same again, unless I delete that standard autocorrection.
My mistake, of course, was to think that the absence of an options pop-up meant that autocorrect wasn't in play.
--
Phil, London
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)