Thread: How can I convert a group of numbers to a group of letters?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarlG CarlG is offline
external usenet poster
  
Posts: 5
Default How can I convert a group of numbers to a group of letters?
How would that work on a digit-by-digit basis, to convert, for example, "256"
to something like "CFI"? (Assuming that A B C D E F G F I and J stood for
0-9)

"Gord Dibben" wrote:

A VLOOKUP table would probably do the trick.

See Excel help on VLOOKUP or go to Debra Dalgleish's site for "real" help.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 15:42:02 -0700, CarlG
wrote:

My store uses a retail price "code" wherein a price like 99 in expressed as a
code like "PP"--exchanging the number digits 1-0 as letters.
Is there a function to do this automatically?


Reply With QuoteReply With Quote