MrExcel Publishing
Your One Stop for Excel Tips & Solutions

seperating text and numbers


Posted by Conor on November 16, 2001 6:29 AM

good day everyone..

how do i pick out a number from a value for example
EUR20.6 ->20.6
PD2345.7 ->2345.7
ie there is mo spaces in it BUT when there is never any chars and numbers mixed up. so does anyone know code to pick out the numbers?????

thanks everyone...


Posted by Aladin Akyurek on November 16, 2001 7:49 AM


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

Aladin

============