<p>函数高手都不在, 我把我的参考答案公布了吧.</p><p>定义名称 num =SUM(ROW(INDIRECT("1:"&LEN(Sheet2!A2)))*10^(ROW(INDIRECT("1:"&LEN(Sheet2!A2)))-1))</p><p> fam="CONCATENATE("& LEFT(TEXT(num,REPT("!m!i!d!("&"!"&CHAR(COLUMN(Sheet2!$A1)+64)&"!"&ROW(Sheet2!$A1)&",0!,!1)!,",LEN(Sheet2!A1))),LEN(TEXT(num,REPT("!m!i!d!("&"!"&CHAR(COLUMN(Sheet2!$A1)+64)&"!"&ROW(Sheet2!$A1)&",0!,!1)!,",LEN(Sheet2!A1))))-1)&")"</p><p>在字符串的左边输入=fan</p><p> </p><p> <br/></p><br/>