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
|