How to separate the texts and numbers resided in a single cell into different columns.

[juchang]

<table width="353" border="0" cellpadding="0" cellspacing="0"><col style="width: 264pt;" width="353"> <tbody><tr style="height: 12.85pt;" height="17"> <td style="height: 12.85pt; width: 264pt;" width="353" height="17"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> Now:
<table class="MsoNormalTable" style="border: medium none ; width: 264pt; margin-left: 4.7pt; border-collapse: collapse;" width="370" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.85pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 264pt; height: 12.85pt;" valign="bottom" width="370" nowrap="nowrap">
program income 1,727,417 1,847,291
</td> </tr> <tr style="height: 12.85pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 264pt; height: 12.85pt;" valign="bottom" width="370" nowrap="nowrap">
revenue 1,346,836 794,213
</td> </tr> </tbody></table>
Need:
<table class="MsoNormalTable" style="border: medium none ; width: 145.05pt; margin-left: 4.7pt; border-collapse: collapse;" width="203" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 23.2pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 48.35pt; height: 23.2pt;" valign="bottom" width="68" nowrap="nowrap">
program income
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48.35pt; height: 23.2pt;" valign="bottom" width="68"> 1,727,417
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 48.35pt; height: 23.2pt;" valign="bottom" width="68"> 1,847,291
</td> </tr> <tr style="height: 23.15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 48.35pt; height: 23.15pt;" valign="bottom" width="68" nowrap="nowrap"> revenue
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.35pt; height: 23.15pt;" valign="bottom" width="68"> 1,346,836
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 48.35pt; height: 23.15pt;" valign="bottom" width="68"> 794,213
</td> </tr> </tbody></table>

Thanks.
</td> </tr> <tr style="height: 12.85pt;" height="17"> <td style="height: 12.85pt;" height="17">
</td> </tr> </tbody></table>

 

[VoG]

Maybe

Excel Workbook
	A	B	C	D
1	program income 1,727,417 1,847,291	program income	1,727,417	1,847,291
2	revenue 1,346,836 794,213	revenue	1,346,836	794,213
Sheet10