朱冠宇期末考EXCEL函數LEFT,MID,RIGHT,LEN,FIND,UNICODE,UNICHAR,從範圍建立名稱
線隨便方一個辨識然後撰寫模式貼上 tmp0 <LI><SELECT ONCHANGE='Check(this.id, this.value, tmp1 )' ID=' tmp2 '><OPTION>答</OPTION><OPTION>1</OPTION><OPTION>2</OPTION><OPTION>3</OPTION><OPTION>4</OPTION></SELECT>\n tmp3 <OL TYPE='1' ID='q tmp4 '>\n<LI> tmp5 </LI>\n<LI> tmp6 </LI></OL></LI> 劉任昌 長度 =FIND(UNICHAR(34),A9) =MID(A9,C9+1,B9-C9-1) tmp0 = "<LI><SELECT ONCHANGE='Check(this.id, this.value, " 58 8 <LI><SELECT ONCHANGE='Check(this.id, this.value, tmp1 = ")' ID='" 16 8 )' ID=' tmp2 = "'><OPTION>答</OPTION><OPTION>1</OPTION><OPTION>2</OPTION><OPTION>3</OPTION><OPTION>4</OPTION></SELECT>\n" 112 8 '><OPTION>答</OPTION><OPTION>1</...