View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Need Formula For Extracting Part Numbers

Hi,

Am Tue, 31 May 2016 19:50:17 +0000 (UTC) schrieb tb:

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


or a bit shorter:
=MID(LEFT(A1,FIND(" ",A1)-1),FIND("_",A1)+1,99)


Regards
Claus B.
--
Windows10
Office 2016