View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confused_in_Houston[_2_] Confused_in_Houston[_2_] is offline
external usenet poster
 
Posts: 15
Default Extracting Numerals From a Text String?

I have several thousand Material Description entries that contain a mix of
text and numerals.

For example: Gasket, high-melt, DLL84848

In the example I would like to ignore the text and simply extract the 84848.
The numbers will not always be in the "last" position; formatting varies
considerably. Is there a way for Excel to recognize numerals in a string of
text?

Thanks