Parsing names, dates, and other information

[Gravedigger]

My hobby of helping cemeteries compile data to help families find loved ones has another spreadsheet for me to start working with (20,000 rows).

Everything is in Column A and it looks like this:
Jones Fred 1822 7-4-1904 24 WI Infantry Co. J Brownville Walnut Grove Nemaha

More examples:
<table style="border-collapse: collapse; width: 660pt;" border="0" cellpadding="0" cellspacing="0" width="876"><col style="width: 110pt;" span="6" width="146"><tbody><tr style="height: 15pt;" height="20"> <td class="xl64" colspan="5" style="height: 15pt; width: 550pt;" height="20" width="730">Brown Abner D. 3-1-1847 12-17-1909 132 IN Infantry Co. A Arnold Arnold Custer </td> <td style="width: 110pt;" width="146">
</td> </tr></tbody></table>
<table style="border-collapse: collapse; width: 660pt;" border="0" cellpadding="0" cellspacing="0" width="876"><col style="width: 110pt;" span="6" width="146"><tbody><tr style="height: 15pt;" height="20"> <td class="xl65" colspan="5" style="height: 15pt; width: 550pt;" height="20" width="730">Brown George 9-1835 5-7-1905 8 US Infantry+ Sgt. Co. A Norden West Norden Keya Paha</td> <td style="width: 110pt;" width="146">
</td> </tr></tbody></table>
Currently it is Last Name- First Name- Middle initial- DateOfBirth -DateOfDeath -CIVIL INFO- City - Cemetery- County

What I need is:
Col B: Last Name
Col C: First name
Col D: Middle Initial or blank if there is no initial listed
Col E: Month # (if one is listed)
Col F: Day # (if one is listed)
Col G: Year
Col H: Month # (if one is listed)
Col I: Day # (if one is listed)
Col J: Year
Col K: Civil War Info
Col L: City
Col M: Cemetery
Col N: County

I know this is not going to be perfect, but the names and dates are the most important. Next important is cemetery and county.

Thanks again!

 

[Joe4]

Please continue in your original post:
http://www.mrexcel.com/forum/showthread.php?t=484064

All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080