| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting a date from a comment field in an excel file
I have exported data from a database into Excel. One of the fields is a
comment field that includes a date in the format of m/dd or m/d. It typically follows the phrase LSD or LSD=. For example the comment may read, "Awaiting LSD 12/27" or "Sale is pending LSD=1/9". I want to be able to extract the date only from this comment field and have it populate in a new column. Is it possible to do this and how do I go about it? Thanks. -- dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data from rows where one field is blank | Excel Discussion (Misc queries) | |||
| Find and Replace in the Comment Field | Excel Discussion (Misc queries) | |||
| Extracting month from a date field | Excel Discussion (Misc queries) | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
