朱冠宇期末考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</OPTION><OPTION>2</OPTION><OPTION>3</OPTION><OPTION>4</OPTION></SELECT>\n

tmp3 = "<OL TYPE='1' ID='q" 27 8 <OL TYPE='1' ID='q

tmp4 = "'>\n<LI>" 17 8 '>\n<LI>

tmp5 = "</LI>\n<LI>" 20 8 </LI>\n<LI>

tmp6 = "</LI></OL></LI>" 24 8 </LI></OL></LI>