| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I extract only certain data from a cell?
Office 2003, Win XP Pro.
I am presented with a worksheet containing dozens of cells in which is contained data of different lengths. eg Zippohat 52131123Sa011880702 Baker 18164 Renatsainv17247 15592 Inv Each contains an invoice number, as follows: 18807 18164 17247 15592 These invoice numbers range between 15000 and 20000 Is there any way to extract only the invoice number from each cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif / Countif - Not certain - want to extract data from cell and | Excel Worksheet Functions | |||
| Extract data from a cell reference | Excel Discussion (Misc queries) | |||
| How do I extract data from every other cell in a colomn? | Excel Worksheet Functions | |||
| how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
| extract data from a realtime updated cell | Excel Discussion (Misc queries) | |||
Threaded Mode
