Extracting numbers from alphanumeric data
=MID(A20,6,3)
--
__________________________________
HTH
Bob
"Flu" wrote in message
...
I have a long list of data which is alphanumeric. I would like to extract
the
string last 3 digits number out.
Is there a quick forumula to it?
e.g.
SK109028-AMP3 - data extract should be 028
504467993AK3 - data extracted should be 993
505747995 - data extracted should be 995
|