还是替换问题

XDYDB

以下是用友软件的二次开发编写的部分公式, LET C4=FS("65",月,"借",,,"P10","","y") LET C5=FS("650",月,"借",,,"P10","","y") LET C6=FS("6500",月,"借",,,"P10","","y") LET C7=FS("6501",月,"借",,,"P10","","y") LET C8=FS("6502",月,"借",,,"P10","","y") LET C9=FS("6503",月,"借",,,"P10","","y") LET C10=FS("6504",月,"借",,,"P10","","y") LET C11=FS("6506",月,"借",,,"P10","","y") LET C12=FS("6507",月,"借",,,"P10","","y") LET C13=FS("655",月,"借",,,"P10","","y") LET C14=FS("6550",月,"借",,,"P10","","y") LET C15=FS("6551",月,"借",,,"P10","","y") LET C16=FS("6552",月,"借",,,"P10","","y") LET C17=FS("6553",月,"借",,,"P10","","y") 怎样在WORD中将以上式中C1\C2\C3....C17变成C2\C3\C4...C18(即C+1)

cxffxc

复制到EXCEL中试试 如果量大值得做，如果量小直接手动改一下就成了。

cxffxc

我在EXCEL中用常规方法做了一个公式，非常复杂： rC7xaFIK.zip (2.24 KB, 下载次数: 14)

2003-12-1 13:24 上传

点击文件名下载附件
还是替换问题

转换结束后选择性粘贴成数值就行了。