| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extracting numbers from alphanumeric cells
I have cells with alphanumeric data, including spaces, e.g, "Accepted by
William A Bell at 4/11/2005 6:40:34 PM" which I need just the month, day, and year information extracted. I have found some information related to extracting numeric data but it does cover the "spaces" issue. Does anyone know how to accomplish this? Can it be accomplished? Appreciate any assistance and expertise you can offer. M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract decimal numbers from alphanumeric strings in Excel | Excel Discussion (Misc queries) | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
| check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
| extracting numbers from string | Excel Discussion (Misc queries) | |||
Threaded Mode
