View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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