| 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 | |||
Linear Mode
