Number-To-Text Autoformat

[JasonBrightwell]

I don't know what you would call this, but what I'd like to do is enter
in numbers in a list & have the cell generate text based on
pre-determined formulas I enter. For example, if I want to make a list
with MAN, WOMAN, and CHILD, assigning them the values 3, 2, and 1,
respectively, I'd like to be able to enter in the numerical values
(1,2,3) instead of having to type the text over & over (CHILD, WOMAN,
MAN).

Any ideas how to do this?

Jason

 

[CyberTaz]

You could create Macros that type in the text and assign keystrokes
like opt+cmd+1, etc., or you could use the Tools>AutoCorrect and assign
each item a unique trigger (such as #m for Man). Other possibilities
exist, but may be more complex than necessary.

HTH |:>)

 

[JasonBrightwell]

That will be adequate for my purposes. Much thanks.