View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Need Formula For Extracting Part Numbers

On 5/31/2016 at 2:50:17 PM tb wrote:

I am using Excel 2010 for Windows.

I have a database of part numbers like this one:

10_32M2A050A002 CYLINDER

Please note that there are two blank spaces between "32M2A050A002" and
"CYLINDER".

I need a formula that will extract each string after the unerscore (_)
sign and the two blank spaces.

So the end result would be this:
32M2A050A002

Thanks for your help.


Thank you Auric__ and Claus.

--
tb