Heather515
New Member
- Joined
- Sep 11, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Need help with extracting date from text strings. I need to extract the date before a keyword. Data and results are shown below. Could somebody help me to write a function or VBA macro. Thanks.
data | result |
NoteNoteNote6/11/2010NoteNote,NoteNote9/22/2012NoteNoteTHISNoteNote,NoteNote4/5/2019NoteNote | 9/22/2012 |
NoteNote5/22/2018NoteNoteTHISNoteNote,NoteNoteNote6/18/2019NoteNote,NoteNote4/18/2019NoteNote | 5/22/2018 |
NoteNoteNote8/18/2018NoteNote,NoteNote4/20/2019NoteNote,NoteNote9/10/2012NoteNoteTHISNoteNote | 9/10/2012 |