Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Motown Mick" wrote in message
...
Dear Ragdyer:

Thanks, that worked. I was able to convert the pdf to excel by first
copying into notepad, then into Excel and playing with the columns.

I dragged the formulae down, and it matched what was in the coding sheet.

Thanks again for all your help.

Mick
"Ragdyer" wrote:

Copy your code list to XL.
Say you enter the numeric data in Y1 to Y50.
Enter your corresponding text data in Z1 to Z50.

With your numeric codes being displayed in Column A, starting in A1,
enter this formula in B1:

=Vlookup(A1,Y$1:Z$50,2,0)

And copy down as far as you have data in Column A.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Motown Mick" wrote in message
...
I have several columns of numeric data that are codes that correspond to
words on a coding sheet that is in a table on a pdf file. I would like
to
know if Excel can do character recognition somehow so as to match the
numeric
codes with their corresponding words, and delineate this somehow on the
Excel
worksheet; preferably in the same column in which the numeric codes
appear.
Although a column immediately adjascent to the numeric codes will also
suffice.

I think there is a way to convert a pdf file to Excel, if that's
necessary
to do first.

Mick