1010_BIERMAN_5530_07092012.pdf 8/31/2012 6:00:22 PM
10469_EVANS_5530_07112012.pdf 8/31/2012 6:00:22 PM
1048_CASTIGLIONE_5510_08212012.pdf 8/31/2012 6:00:22 PM
10499_LAUDERDALE_5520_07052012.pdf 8/31/2012 6:00:22 PM

Okay folks. I Need each of the examples split up (in a macro) to seperate everything before/after a _ to a seperate column.
There are three exceptions
1)***HOWEVER, the .pdf can get taken out of the end***
2)***I need to convert the last numbers (before the .pdf) into date format (MM/DD/YYYY) (I.e 07052012 would be 7/5/2012)
3)***If the cell contains something like 8/31/2012 6:00:22 PM (after a bunch of the spaces) then please insert This Date(+TIME) into ANOTHER column. I am not certain each pdf name will have a separate date attached, but for this example, they are***

In Total, 5 columns (correct me if I am wrong)

This would be a huge life saver. Thanks so much guys!