Shorthand mnemonic key entry

[Joe Was]

Has anyone worked out a method for entering information by code-key-stroke in Excel, like on a "Palm Pilot." On a Palm Pilot you hit the "Shorthand" key and type your code and the codes value replaces your keyed code, like:
(~JW) gives: Joe Was and (~JSW) gives: Joseph S. Was, as the displayed text?

P.S: There may be a built-in Excel utility for this that I don't know of? JSW

_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o></o></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o></o></span>[/b]
This message was edited by Joe Was on 2002-08-22 11:09

 

[Jim North]

Hi Joe,

You could use Excel's autocorrect feature...

TOOLS/AUTOCORRECT

 

[Joe Was]

Jim,
In autocorrect how would you distigish between real information and code?

Like: NA and NA where NA = NA(Not Available) and NA(North America)?
Have you worked out a system that works for you? JSW

 

[Joe Was]

Jim,
You were right, I did not think Excel would let me use the "~" as a code indicator in autocorrect, but it does. It does not seem to cause any problems and works in most actions. Thank's, JSW.