I'm trying to use AutoCorrect to insert special characters. (It'd be nice if
I could create shortcuts for them like I can in Word -- sigh...but even Word
inserts the character in the font in which it was created and not the font
I'm working LoL Nothing is perfect. Oops! Wrong forum.)
Anyway, I've added my AutoCorrects to the list, and I have
"Tools-Autocorrect Options...-[X] Replace text as you type" turned on. I
even have the entire worksheet formatted as text. But Excel doesn't
autocorrect anything I type. What am I doing wrong?

Jason

What types of special characters did you add to the AC list and which letter or
combination of letters should trigger the AC?

e.g. qwerty replace with Alt + 0186

123qwerty would give you 123º


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 14:52:00 -0700, WJason
wrote:

I'm trying to use AutoCorrect to insert special characters. (It'd be nice if
I could create shortcuts for them like I can in Word -- sigh...but even Word
inserts the character in the font in which it was created and not the font
I'm working LoL Nothing is perfect. Oops! Wrong forum.)
Anyway, I've added my AutoCorrects to the list, and I have
"Tools-Autocorrect Options...-[X] Replace text as you type" turned on. I
even have the entire worksheet formatted as text. But Excel doesn't
autocorrect anything I type. What am I doing wrong?

Jason

Did you finish the word with a space character or a punctuation mark or by
hitting enter or tab.

If you did, then share the word you added to the list and the autocorrected
entry.

And give details about how you did the data entry.

WJason wrote:

I'm trying to use AutoCorrect to insert special characters. (It'd be nice if
I could create shortcuts for them like I can in Word -- sigh...but even Word
inserts the character in the font in which it was created and not the font
I'm working LoL Nothing is perfect. Oops! Wrong forum.)
Anyway, I've added my AutoCorrects to the list, and I have
"Tools-Autocorrect Options...-[X] Replace text as you type" turned on. I
even have the entire worksheet formatted as text. But Excel doesn't
autocorrect anything I type. What am I doing wrong?

Jason

--

Dave Peterson

I'm trying to use AutoCorrect to insert special characters.
I've added my AutoCorrects to the list, and I
have "Tools-Autocorrect Options...-[X] Replace text as you type"
turned on. I even have the entire worksheet formatted as text. But
Excel doesn't autocorrect anything I type. What am I doing wrong?

AutoCorrect is really intended for whole words, not individual characters.

I've worked around this by using a "Replace" string that starts and ends
with punctuation; for example, replace
,n,
by Spanish "n with tilde." This works even if the "replace string" is in
the middle of a word.

(I have Excel 2003.)