=LEFT(Sheet1!$A$1,FIND("*",Sheet1!$A$1)-1)
=MID(Sheet1!$A$1,FIND("(",Sheet1!$A$1)+1,FIND("+",Sheet1!$A$1,FIND("*",Sheet1!$A$1)+1)-FIND("(",Sheet1!$A$1)-1)
=MID(Sheet1!$A$1,FIND("+",Sheet1!$A$1)+1,FIND(")",Sheet1!$A$1)-FIND("+",Sheet1!$A$1)-1)
=MID(Sheet1!$A$1,FIND(")",Sheet1!$A$1)+2,18)
每条的函数是什么意义
有什么作用
本帖最后由 zhc3288 于 2011-5-21 17:48 编辑
LEFT是提取表1中A1单元格中*号左边的字符,=MID($A$1,FIND("(",$A$1)+1,FIND("+",$A$1,-FIND("(",$A$1)-1))是从A1的单元格中从(开始计算位数,后边是返回几位,大致是这样的,提取几位动态的,这两个函数好像是A1中是一个较复杂的文本,里面包涵了(、*、+符号,从中提取想要的字符
|