Converting numbers to letters

Originally Posted by jolumbo

I have a chart with the alpabet in the first column in the next four columns are numbers that correspond to the letters in the 1st column. How can I use MS Word to reference my chart and convert these numbers to letter and vise versa. Also since I have 4 seperate columns of numbers. I need to be able to specify which column of numbers I want to be used to deciper my alphbet. Does anyone have any ideas on the best way to do this? Basically it is making 4 seperate decoder wheels/rings but just automated so it will decipher what is typed in Word (alpha or numeric). Thanks for you help.

Hello,

MS Word ? err No.

But if you want to do it in Excel, copy column A as column F then use data in column G as:

=VLookup(G1,A:D,2,False)
to convert letter to column B number

=VLookup(G1,A:D,3,False)
to convert letter to column C number

=VLookup(G1,A:D,4,False)
to convert letter to column D number

=VLookup(G1,A:E,5,False)
to convert letter to column E number

=VLookup(G1,B:F,5,False)
to convert column B to letter

=VLookup(G1,C:F,4,False)
to convert column C to letter

=VLookup(G1,D:F,3,False)
to convert column D to letter

=VLookup(G1,E:F,2,False)
to convert column E to letter

hth
---amended column E

Originally Posted by jolumbo

Bryan,
That worked good for translating a single character/number, but I need to be able to do an entire string ie: tanslating letters to and from a friend. Is there something I can add that would allow me to do that. When I am translating numbers they will always be: two digits a space and then two more digits and so on till it makes up words/sentences.

Thanks,
Keith

Hi,

For a word or two you could use Text to Columns and lookup sideways, but I'll look at some code tomorrow if you get no better offers.

Where will your code, table, and Key be?


---