| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Instead of Parsing
I have a field in my spreadsheet from a query, as follows.
01*24*50076*01*EA*05 01*22*ZMAPLE*01*EA*05 I am interested in extracting the middle characters like 50076 ZMAPLE They are the Item numbers and they float between 5 and 8 charcaters. How can I accomplish? Also I have another field. 01*09*ZZQUA*01*CS*06 01*21*80225*01*CS*03 I would like to separate in addition to Item number 4th and 5th characters. Thanks for helping me. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Instead of Parsing
Use Text to Columns with the * as the separator.
-- Gary's Student "Krish" wrote: I have a field in my spreadsheet from a query, as follows. 01*24*50076*01*EA*05 01*22*ZMAPLE*01*EA*05 I am interested in extracting the middle characters like 50076 ZMAPLE They are the Item numbers and they float between 5 and 8 charcaters. How can I accomplish? Also I have another field. 01*09*ZZQUA*01*CS*06 01*21*80225*01*CS*03 I would like to separate in addition to Item number 4th and 5th characters. Thanks for helping me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing in Excel? | Excel Worksheet Functions | |||
| Excel & HTML Parsing | Excel Discussion (Misc queries) | |||
| Formulas for Parsing Full names | Excel Worksheet Functions | |||
| Parsing 124A into 124 | Excel Worksheet Functions | |||
| Parsing words in excel cells | Excel Worksheet Functions | |||
Hybrid Mode
