Thank You All

for your views.

Since the number of items seems to be important, I will give you an
idea of the size.

I have about 300 separate number codes to translate into descriptive
words and short phrases. This in many thousands of records contained
in a few dozen databases. Not the kind of thing that I can do by hand
in one lifetime.

Under these conditions, what do you think is the best way to go?

Best Regards,

Arthur

************************************************** ****

On Tue, 02 Aug 2005 20:46:11 -0400, goseespam@lot wrote:

How can I express this?

Assume 2 columns, A and B.
In A, a col of numbers: 1, 2, 3, etc.
In B, now empty, I need to have a col of words that describe in words
what the numbers stand for: apples (for No 1), oranges (for No2),
lemons (for No 3), etc.

I already have the col with the numbers, Column A. I need a way to
tell Excel to fill in col B with the word "apple" wherever it sees a
"1" in col A. And to fill in col B with the word "oranges" whereever
it sees the number "2" in col A. etc, etc.

Is this do-able?

Best Regards,

Arthur