my name is tim robins I was born 1/1/1980 at 1:30 AM in a small house in ny. Today is 2/2/2016 3:30. Bob walked 3 miles Wednesday 5/1/2016 at 5:15 PM. | Born 1/1/1980 at 1:30 | Today is 2/2/2016 3:30 | Wednesday 5/1/2016 at 5:15 | |
Terminal 27 log 15 Date 7/3/2016 time 1:00. Happy Friday 5/1/2016 at 5:15 PM. | Date 7/3/2016 time 1:00 | Friday 5/1/2016 at 5:15 | ||
Accession number 23435 date accessioned 9/5/2016 at 1:00. Tom Johnson 5/15/2016 4:13 bring your drink to here on 12/25/16 at 3:00 PM for fun. Don’t know what else to write 1/1/1999 3:22 | accessioined 9/5/2016 at 1:00 | Johnson 5/15/2016 4:13 | here on 12/25/16 at 3:00 | write 1/1/1999 3:20 |
<tbody>
Hi Guys,
New to macros and this is my first post. I am trying to create a macro to pull the date (plus the previous words) out of a string in the previous cell. Any help is appreciated, here is a chart demonstrating what I am trying to do (column A has the string, B-... is where I want the dates to be entered):
</tbody>