View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Flu Flu is offline
external usenet poster
 
Posts: 5
Default Extracting numbers from alphanumeric data

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