Need Formula For Extracting Part Numbers
 

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.
--
tb

Need Formula For Extracting Part Numbers
 

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.

Assuming your text is in A1:

=MID(A1,FIND("_",A1)+1,FIND(" ",A1)-FIND("_",A1)-1)

--
The clouds move lazily across the sky,
and everybody thinks they're stupid.

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

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