Please help.

I'm doing a very large database and I need help to separate alphanumeric combination of text and date from one cell to two new column. I used to use Text to Column but there's overlap and taking me an ample time to clean up. Also, I need that for example there's only text and no date then the content of the cell willappear and not give me error. Please see snapshot and what I need to separate.

Capture.JPG