| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract specific value using SEARCH FORMULA
Hi,
Below is text and underneath is a formula to extract a number (53625) from Text after "PMT DET". Since this number is broken down between two rows, it is not extracting the value as desire and gives "#value! error. How can fix the formula? thanks in advance. Dinesh Text "WIRE TYPE:WIRE OUT DATE:060231 TIME:1219 ET TRN:3001014500160362 SERVICE REF:002067 BNF:DISTRIBUTED SYSTEMS SERVIC ID:ab68068pc BNF BK:NATIONAL BENN CORP ID:031308784 PMT DET:536 25 KMC-65069 INV a000G5202 0000ab /152 " Formula =IF(ISERROR(SEARCH("WIRE TYPE:WIRE",D25)),"",MID(D25,SEARCH("PMT DET:",D25)+8,5)+0)&IF(ISERROR(SEARCH("WIRE TYPE:BOOK",D25)),"",MID(D25,SEARCH("REF:",D25)+4,5 )+0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to extract a specific word from text string | Excel Worksheet Functions | |||
| I need to search for then extract a specific portion of cell data... | Excel Worksheet Functions | |||
| Search/Extract Formula | Excel Discussion (Misc queries) | |||
| filename search and extract into a cell | Excel Discussion (Misc queries) | |||
| formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Threaded Mode
