Quote 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?


---