期末考EXCEL函數LEFT,MID,RIGHT,LEN,FIND,UNICODE,UNICHAR,從範圍建立名稱

先隨便方一個辨識然後撰寫模式貼上

Atmp0 <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 MID 字碼

tmp0 = "<LI><SELECT ONCHANGE='Check(this.id, this.value, " 58 8 <LI><SELECT ONCHANGE='Check(this.id, this.value, " 34

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>