Removing Text from numbers

[Michael]

Help!!! Is there a way in a string numbers ending with
text to seperate the numbers from the text. Sample data
24594A 24594B 12345MIK 123AB The numder of numbers and
text are variable.

Thanks
Michael

 

[GerryK]

Try adapting this, array entered

=LEFT(A1,MIN(IF(1-ISERROR(FIND({1,2,3,4,5,6,7,8,9},A1)),
FIND({1,2,3,4,5,6,7,8,9},A1)))-1)&
RIGHT(A1,LEN(A1)-MAX(IF(1-ISERROR(FIND
({1,2,3,4,5,6,7,8,9},A1)),
FIND({1,2,3,4,5,6,7,8,9},A1))))

Gerry

 

[Aladin Akyurek]

=SUBSTITUTE(A1,SUBSTITUTE(A1,LEFT(A1,SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,{
0,1,2,3,4,5,6,7,8,9},""))))),""),"")+0

which expects a series of digits followed by a series of non-digits.