text file to excel

[shadyshawn]

I got a report exported from another program, but is in rtf format (something like below):<table class="MsoNormalTable" style="width:368.0pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt" border="0" cellpadding="0" cellspacing="0" width="491"><tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"><td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] ID Name Date: 08/09/11[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] 15808 Smith, Joe [/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Sick, Unsched Unpd 9:30 100.00%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Total 9:30[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:8;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] 6981 Doe, Jane [/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Sick, Unsched Unpd 9:30 100.00%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Total 9:30[/FONT]
</td> </tr> <tr style="mso-yfti-irow:11;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:12;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] 14652 Leblanc, Johnny [/FONT]
</td> </tr> <tr style="mso-yfti-irow:13;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Late Unpd 1:02 88.57%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:14;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Late from Break Unpd 0:06 8.57%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:15;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Unauth Unpaid Break 0:02 2.86%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:16;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Total 1:10[/FONT]
</td> </tr> <tr style="mso-yfti-irow:17;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491">
</td> </tr> <tr style="mso-yfti-irow:18;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] 6166 Macy, Linda [/FONT]
</td> </tr> <tr style="mso-yfti-irow:19;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Sick, Unsched Unpd 3:30 100.00%[/FONT]
</td> </tr> <tr style="mso-yfti-irow:20;mso-yfti-lastrow:yes;height:12.75pt"> <td style="width:368.0pt;padding:0cm 5.4pt 0cm 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="491"> [FONT=&quot] Total 3:30[/FONT]
</td> </tr> </tbody></table>
Is there way I can format the data into something like this after pasting it into excel? I tried to use text to column but didn't get what I needed.

[FONT=&quot]Smith, Joe[/FONT][FONT=&quot] Sick, Unsched Unpd [/FONT][FONT=&quot] [/FONT][FONT=&quot]9:30 [/FONT]
[FONT=&quot] Doe, Jane [/FONT][FONT=&quot] Sick, Unsched Unpd 9:30 [/FONT]
[FONT=&quot]Leblanc, Johnny[/FONT] [FONT=&quot]Late Unpd 1:02 [/FONT]
[FONT=&quot]Leblanc, Johnny[/FONT] [FONT=&quot]Late from Break Unpd 0:06 [/FONT]
[FONT=&quot]Leblanc, Johnny [/FONT][FONT=&quot]Unauth Unpaid Break 0:02[/FONT]

Any help is greatly appreciated!

 

[shadyshawn]

anyone can help?