WPS怎么把G5中的号码批量分行与A列的名字相对应,如图!答:K5单元格输入公式=IFERROR(IF(COLUMN()=11,INDEX(LEFT($G$5:$G$100,FIND(" ",$G$5:$G$100)-1),SMALL(IF(LEN($G$5:$G$100)-LEN(SUBSTITUTE($G$5:$G$100," ",))>=COLUMN($A:$DZ),ROW($G$5:$G$100)-4),ROW(A1))),MID(PHONETIC($G$5:$G$100),FIND("@",...