Extracting Digits.

[serge]

Hi everyone,


I'm looking for a formula that will extract, all the digits used in a series of 5 number, minus 1,2,3.
See example below.

Thank you.

Excel Workbook
	D	E	F	G	H	I	J
5	8	27	32	35	38		5788
6	1	9	10	23	28		089
7	5	20	27	27	30		00577
Sheet

 

[Ron Coderre]

OOPS! Forgot to make sure zeros list...
Try this array-formula:

J5: =REPT("0",LEN(D5&E5&F5&G5&H5)-LEN(SUBSTITUTE(D5&E5&F5&G5&H5,0,"")))&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUM(
SMALL(--MID(D5&E5&F5&G5&H5,ROW(INDIRECT("1:"&LEN(D5&E5&F5&G5&H5))),1),
ROW(INDIRECT("1:"&LEN(D5&E5&F5&G5&H5))))*10^(LEN(D5&E5&F5&G5&H5)-
ROW(INDIRECT("1:"&LEN(D5&E5&F5&G5&H5))))),0,""),1,""),2,""),3,"")

 

[serge]

Tank you Ron, your formula work very well too, I appreciate it.
Serge