View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Capturing Part Numbers Within Text Strings

I need to capture part numbers that are embedded in text strings.

For instance, the string in A1 is:

9UNI01 05A4462-300202 US1U US1C Standard

....and I am looking for a function (in B1) that will capture the part
number, i.e.:

05A4462-300202

The part numbers are always in the second position of a string and
separated --right and left of them-- by several blank characters.

Thanks.
--
tb