Grüezi Paul

Paul Black schrieb am 03.02.2005

0112110000
0221000001
0221100000
0011201100
0011300100

What I would Like is to Condense ( Using a Formula ) EACH 10 Digit
Number Down to ONLY Digits Greater Than One. For Example :-

Number 0112110000 Becomes 11211
Number 0221000001 Becomes 2211
Number 0221100000 Becomes 2211
Number 0011201100 Becomes 11211
Number 0122100000 Becomes 11221

With the last one I don't agree ;-)

....but try the following formula:


=SUBSTITUTE(A1;"0";"")



Regards
Thomas Ramel

--
- MVP for Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]