Hi.

I've got a mess of a file that I have to use - some data dump that submits in .csv format, but the dates won't convert to a date value.

Here's two examples of how the dates come:

xxxxxxxxOctxx8x2010xx7:00AMx

OR

xxxxxxxxOctx10x2010x10:00AMx

X's here represent blanks in the file. The number of spaces are the same at the beginning of the field, but then they vary from there.

Anyone have an idea of a formula that I can insert for all rows to convert this into a date value?

Any help would be hugely appreciated...

Thanks!!!

Nate.