| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract data from a cell
This should be easy but somehow it just escapes me how to do this. I need to
extract a birthdate from a text string. For example, the text string 12VEC1461001 parses left to right into 12= month, VEC = not required, 14 = day, 61= year, 001 = not required. Column/Row C2 is 12VEC1461. In Column/Row D2 I need 121461 in date format 12/14/61. Thanks, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract data from a cell | Excel Worksheet Functions | |||
| how do I extract only certain data from a cell? | Excel Discussion (Misc queries) | |||
| 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 | |||
| Extract Data Between Cell Ranges | Excel Programming | |||
Threaded Mode
