[男主角所有数值最高]ON=3182,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27[女主角所有数值最高]ON=31BE,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27[第3人所有数值全满]ON=31BE,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;31FA,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27[第4人所有数值全满]ON=31BE,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;31FA,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;3236,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27[无限金钱]ON=31BE,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;31FA,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;3236,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27,F,27;3258,7F,96,98[全道具]ON=3B86,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99,99
參考答案:不需要用VB就可以实现
在EXCEL中，先把手机号那列单独放到前面，然后就把姓名以及几个成绩连续，在其后的一个空白单元格中输入函数
=CONCATENATE(A2," 语文",,B2," 数学",C2," 英语",D2)
测试时A1列为手机号码，A2列为姓名，B2列为语文成绩，C2列为数学成绩，D2列为英语成绩……。CONCATENATE是EXCEL用来拼接文本的函数。
