Remember Me?

#1
May 31st 16, 08:50 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 84
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

#2
May 31st 16, 08:59 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2003 Posts: 535
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.
#3
May 31st 16, 09:36 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,853
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
#4
May 31st 16, 10:57 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 84
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

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post cardan Excel Programming 5 June 7th 12 05:33 PM Kwokman3 Excel Discussion (Misc queries) 14 June 1st 09 03:57 AM ob3ron02 Excel Worksheet Functions 5 October 30th 04 12:35 PM ob3ron02 Excel Worksheet Functions 1 October 29th 04 07:05 PM ob3ron02 Excel Worksheet Functions 1 October 29th 04 06:07 PM

All times are GMT +1. The time now is 10:38 AM.