Home 
Search 
Today's Posts 
#1




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




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




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




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Extracting a Part of a Formula as Text  Excel Programming  
Help Extracting Numbers formula  Excel Discussion (Misc queries)  
Formula for Extracting Alphabetic Part of a Product Code  Excel Worksheet Functions  
Formula for Extracting Alphabetic Part of a Product Code  Excel Worksheet Functions  
Formula for Extracting Alphabetic Part of a Product Code  Excel Worksheet Functions 