I was able to do it in a *very* crude way. I used the MID function t
get each number in the cell. The +0 converts the extracted number bac
to number format as the MID function makes it text.

Maybe someone will see this mess and write a nice VBA function tha
reads each number into an Array and then adds them together. I trie
but I lack the skills.

Here is the non programmer way:

For instance:

Cell A1 = 15449 Cell B1 = 47165

Cell C1:
= (MID(A1,1,1))+0 + (MID(A1,2,1))+0 + (MID(A1,3,1))+0 + (MID(A1,4,1)
+0 +(MID(A1,5,1))+0

Cell D1:
=(MID(B1,1,1))+0 + (MID(B1,2,1))+0 + (MID(B1,3,1))+0 + (MID(B1,4,1)
+0 +(MID(B1,5,1))+0

Cell E1:
=AVERAGE(C1,D1)

Highlight C1, D1 and E1 and then drag down (assuming that you hav
other values in columns A and B).

Of course if you numbers vary in length you will have more work to do.

---
You could combine all this into one cell to acomplish what you asked
for: "=(1+5+4+4+9)/(4+7+1+6+5)" which is not the same as averaging th
two.

Cell C1:

=((MID(A1,1,1))+0 + (MID(A1,2,1))+0 + (MID(A1,3,1))+0 + (MID(A1,4,1)
+0 +(MID(A1,5,1))+0) / ((MID(B1,1,1))+0 + (MID(B1,2,1))+0
(MID(B1,3,1))+0 + (MID(B1,4,1)) +0 +(MID(B1,5,1))+0)


Fre

--
Fred
-----------------------------------------------------------------------
Fredg's Profile: http://www.excelforum.com/member.php...fo&userid=2632
View this thread: http://www.excelforum.com/showthread.php?threadid=46688