Excel Formatting, Formatting formula

Hi! am using MS Excel 2007
===========================
1:

I have a column mentioning values:

Column 1:

Eight. Four
Seven. 0ne
Nine. Eight
Eight. Eight
Six. 0ne

I need results as :

Column 2:

8.4
7.1
9.8
8.8
6.1...
============================

2:

Problem.......
Column 1:

Nine Hundred Sixty Three Thou sand Seven Hu ndred Eighty One
Eight Hundred Sev enty Eight Thousand E ight Hundred Seventy Eight
Eight Hundred Twenty Two Thous and Seven Hundred Eighty Four
Eight Hund red Twenty Six Thousand One Hundred Eighty Nine
Nine Hundred Three Thousand Ni ne Hundred Six


Result
Column 2:

Nine Hundred Sixty Three Thousand Seven Hundred Eighty One
Eight Hundred Seventy Eight Thousand Eight Hundred Seventy Eight
Eight Hundred Twenty Two Thousand Seven Hundred Eighty Four
Eight Hundred Twenty Six Thousand One Hundred Eighty Nine
Nine Hundred Three Thousand Nine Hundred Six

i.e.: The result should take off all <spaces> followed by "small letters" ('Hu ndred' - 'Hundred' in first case)


I appreciate your valuable suggestions........ thank you!