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