On Tue, 28 Jun 2005 13:35:02 -0700, "jplazola"
wrote:

I am trying to find a formula that will convert existing number combinations
into corresponding letter combinations in Excel. The relationship of numbers
to letters is as follows:
1 = A 6 = F
2 = B 7 = G
3 = C 8 = H
4 = D 9 = I
5 = E 0 = J

For example, I'd like to convert a cell that contains '1250' to 'ABEJ'

I've had no success with the HELP feature in Excel.

Thank you for any help you may provide
Jason


The problem is concatenating the resultant array of letters. One solution to
that problem is to go to http://xcell05.free.fr/english/.

and download and install Longre's free morefunc.xll add-in.

Then use the MCONCAT function in this *array* formula:

=MCONCAT(CHOOSE(1+MID(A1,ROW(INDIRECT(
"1:"&LEN(A1))),1),"J","A","B","C","D","E","F","G", "H","I"))

To enter an array formula, after typing or pasting it in, hold down
<ctrl<shift while hitting <enter. Excel will place braces {...} around the
formula.


--ron