[求助]如何拆分数据

zaq03

<table cellspacing="0" cellpadding="0" width="310" border="0" style="WIDTH: 233pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="310" style="WIDTH: 233pt; mso-width-source: userset; mso-width-alt: 9920;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td width="310" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 233pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体">下边的内容如何直接用公式直接取到，05工行01，04中行债01</font>，<font face="宋体">04中行债02，07魏桥CP01等等，谢谢！<br/></font><font face="宋体"></font></p><p><font face="宋体">长期金融机构债券面值-05工行01</font></p></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">长期金融机构债券面值-04中行债01</font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">长期金融机构债券面值-04中行债02</font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="317" border="0" style="WIDTH: 238pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="317" style="WIDTH: 238pt; mso-width-source: userset; mso-width-alt: 10144;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td width="317" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 238pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">其他短期债券投资-07魏桥CP01</font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">其他短期债券投资-07南电CP01</font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">其他短期债券投资-07连云港CP01</font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">其他短期债券投资-07三河CP01</font></td></tr></tbody></table>

liujy

<p>用MID，下列附件供参考：</p> lv6vAlK0.rar (1.91 KB, 下载次数: 14)

2007-5-17 10:58 上传

点击文件名下载附件
[求助]如何拆分数据

<br/>

xlonger

数据 分列

zaq03

谢谢大家。特别谢谢2楼的<strong><font color="#61b713">liujy</font></strong>