Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |