<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>willin2000</i>在2007-10-18 22:48:00的发言:</b><br/><p>第二题,参考2楼.</p><p>定义名称bb=EVALUATE((REPT("SUBSTITUTE(",8)&CELL("address",!$B11)&TEXT(12345670,REPT("\,\""0\"",\)",8))))</p><p>D11=SUBSTITUTE(SUBSTITUTE(bb,"8",),"9",)</p><br/></div><p>Evaluate用得很棒!再节省点儿,去掉8个字符: </p><p>bb=EVALUATE((REPT("SUBSTITUTE(",8)&<strong>CELL</strong>("address",!$B11)&TEXT(12345670,<strong>REPT("\,0\,)",8)</strong>)) </p><p>再再节省点儿,再去掉13个字符,而且没有使用<strong>易失性函数</strong>: </p><p>bb=EVALUATE(REPT("SUBSTITUTE(",8)&<strong>"B"&ROW()</strong>&TEXT(12345670,REPT("\,0\,)",8)))</p><p>D11=SUBSTITUTE(SUBSTITUTE(bb,<strong>8,),9,</strong>)</p>
[此贴子已经被作者于2007-11-21 3:53:36编辑过] |