Hello.
I have a varying text string that includes dates in various formats. I would like to have all dates removed but retain the other non-date text.
Current:
012 CHI record debt AUG-12 13-AUG-2012 12:35:12 issue
"Reverses 012 CH AUG-12 15-AUG-2012" 74923828
044 GHI insurance 13-AUG-2012 33238922 SEP-12
Desired:
012 CHI record debt issue
"Reverses 012 CH" 74923828
044 GHI insurance 33238922
Also, if there is an easy way to parse the 9 digit number that would be great but I can handle it with a formula.
Thanks!
Bookmarks