Removing Text from numbers

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
=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.
 
Back
Top