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
|