Hi,

It may be as simple as this if all your strings are the same length

=MID(A1,30,10)

Mike

"Cathy Landry" wrote:

Hello,

We have concatenated data loaded into Oracle in att 5. I have exported this
to Excel and now need to pull out the transaction dates and put them into
another column. The data below shows what is contained in one cell and the
transaction date is the second date listed that I need pulled into a separate
cell in Excel

Any help would be appreciated!

24493989153026554078566-1_629430_198_7661_06/02/2009_06/01/2009_06/10/2009_06/16/2009_384149_2361257_3487911_72703_584423_E1C73691_ 4789

Thank you!
Cathy