excel中如何在拼音字母间加空格?答:假如数据在A列并从A1开始,在B1单元格输入公式=IFERROR(LEFT(A1,LOOKUP(,0/(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<=90),ROW(INDIRECT("1:"&LEN(A1)))-1)&" "&TRIM(MID(A1,LOOKUP(,0/(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<=90),ROW(INDIRECT("1:"&L...