Search This Blog

Wednesday 20 June 2012

EXTRACT NUMBERS FROM AN ALPHANUMERIC STRING WHEN NUMBERS ARE NOT CLUSTERED


Alphanumeric StringNumbers
RED458ELT94589
s324rake8ete3248
drk77dFTT563j77563
FKD5RR5
4tryr3514351
3fdffd4f5345
Rkknk4656s4656
9c5vcv933`90923]]9593390923
À87&‰ð$ 45§§Ø7çz24[8745724
~9¯œ»~ô855‹eg87Û©3798558737



Array Formula:

=NPV(-0.9,,IFERROR(MID(A58,LEN(A58)-ROW(INDIRECT("1:"&LEN(A58)))+1,1)%,""))

Press Ctrl+Shft+Enter

No comments:

Post a Comment