Re: summing numbers with in a cell
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Wed, 06 Jul 2005 14:52:00 -0400
On Wed, 6 Jul 2005 11:57:49 -0500, the-charles
<the-charles.1rrcil_1120669560.9455@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
>in cell a1 i have 4099227911503, i know that if i add these numbers up,
>the sum would be 52. how do i write a formula that will do the same
>thing. i need to add the numbers with in the cell so that i can do a
>mod 10 to get the check digit. i am creating a data base for merging
>with envelopes and i need to put the planet code "a1" with a check
>digit
You may use this array formula:
=SUM(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
To enter an array formula, after typing or pasting it into the formula bar,
hold down <ctrl><shift> while hitting <enter>. Excel will place braces {...}
around the formula.
--ron
.
- References:
- summing numbers with in a cell
- From: the-charles
- Re: summing numbers with in a cell
- From: swatsp0p
- Re: summing numbers with in a cell
- From: the-charles
- summing numbers with in a cell
- Prev by Date: Re: how to disable save prompt on closing excel file in automated mode
- Next by Date: Re: macro status indicator
- Previous by thread: Re: summing numbers with in a cell
- Next by thread: Re: summing numbers with in a cell
- Index(es):
Relevant Pages
|
