extract text(alphanumeric combi) and date to two separate column

[lati2008]

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

[Phuocam]

Try this ...

1. =LEFT(A1,LEN(A1)-11)

2. =--RIGHT(A1,10)

[Lemice]

Hello,

Assuming that your data starts from row 3, in columns F, G and H like in the snapshot, you can try this formula in H3:

Please Login or Register  to view this content.

And this in G3

Please Login or Register  to view this content.