View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Extraction of Part Numbers from Text Strings

Hi,

Am Sat, 9 May 2020 08:55:47 -0500 schrieb tb:

Unfortunately our parts have different descriptions...


then try:

=IF(ISNUMBER(--MID(A1,2,1)),LEFT(A1,FIND(" ",A1)-1),IFERROR(MID(A1,FIND(" _",A1)+2,8),MID(A1,FIND(" ",A1)+2,99)))


Regards
Claus B.
--
Windows10
Office 2016