Performing multiple Find/Replaces All At Once?

[dbedro]

Hello, regarding my issue here is a very brief summary. I have a
database that stores "country of origin" quantitatively based on a
standardized document called the Huridocs. When I run data queries for
reports I need to present this quantitative data in standard text form
(i.e. "1234" coding must become "China"). As a result, I must go
through manually doing a "Replace" for each country code to its text
equivalent so that my supervisor can do write up's for grants based on
the data.

What I wanted to know was if it is possible to have a pre-set "Replace"
command where I enter in ahead of time all of the quantitative country
codes as the variable to "find" and their corresponding country text's,
as the variable to "replace" the codes with. then instead of replacing
the codes one-by-one I could just run this single command that goes
through the spreadsheet and automatically replaces all of them.

Sorry if my lingo is off, but I work for a non-profit and im a
self-taught database manager, so i've learned by doing,
trial-and-error. I appreciate any assistance.

Regards

Darren

 

[Roger Govier]

Hi Darren

On another sheet say Sheet2, set up 2 columns of data. Column A the
codes - 1234 etc, and in column B alongside, their Text equivalent -
China.
On your main sheet, supposing the numbers are in column C, then in
column D enter
=VLOOKUP(--C1,Sheet2!$A$1:$B$!00,2,0)
and copy down the sheet as far as necessary.Change the range to suit.
The double unary minus in front of C1 is to convert any text entries of
1234 to numeric, assuming that you have set up numeric's in column A of
Sheet2.

 

[dbedro]

Robert

I tried it as your directions indicated and it did not work. Within the
same workbook, I added a second spreadsheet named "Sheet2" and attempted
to follow your directions

The only part I was confused about was the "Range" portion of your
response. Everything else i did as close to verbatim to your directions
as was possible. Any chance you could email me a spreadsheet with this
already done to it so I could see it? I learn well when I can take
something apart and put it back together. if not any other help you
could offer would be appreciated. Ill keep trying to get it to work on
my end.