Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Part Numbers Within Text Strings
I need to capture part numbers that are embedded in text strings.
For instance, the string in A1 is: 9UNI01 05A4462-300202 US1U US1C Standard ....and I am looking for a function (in B1) that will capture the part number, i.e.: 05A4462-300202 The part numbers are always in the second position of a string and separated --right and left of them-- by several blank characters. Thanks. -- tb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Part Numbers Within Text Strings
Hi,
Am Wed, 1 May 2019 16:40:28 +0000 (UTC) schrieb tb: I need to capture part numbers that are embedded in text strings. For instance, the string in A1 is: 9UNI01 05A4462-300202 US1U US1C Standard ...and I am looking for a function (in B1) that will capture the part number, i.e.: 05A4462-300202 The part numbers are always in the second position of a string and separated --right and left of them-- by several blank characters. try: =LEFT(TRIM(MID(A1,FIND(" ",A1),99)),FIND(" ",TRIM(MID(A1,FIND(" ",A1),99)))) Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capturing Part Numbers Within Text Strings
On 5/1/2019 at 12:04:29 PM Claus Busch wrote:
Hi, Am Wed, 1 May 2019 16:40:28 +0000 (UTC) schrieb tb: I need to capture part numbers that are embedded in text strings. For instance, the string in A1 is: 9UNI01 05A4462-300202 US1U US1C Standard ...and I am looking for a function (in B1) that will capture the part number, i.e.: 05A4462-300202 The part numbers are always in the second position of a string and separated --right and left of them-- by several blank characters. try: =LEFT(TRIM(MID(A1,FIND(" ",A1),99)),FIND(" ",TRIM(MID(A1,FIND(" ",A1),99)))) Regards Claus B. Thanks, Claus! -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With Searching For Strings In Part Numbers | Excel Worksheet Functions | |||
Capturing a word sequence as part of a text in a spreadsheet cell | Excel Worksheet Functions | |||
2 more questions about extracting numbers from text strings | Excel Discussion (Misc queries) | |||
Text strings recognized as numbers given different regional settin | Excel Programming | |||
ADO inserts text strings not numbers when table is empty | Excel Programming |