excel字符串拼接雙引號(hào)（excel字符串拼接）

關(guān)于excel字符串拼接雙引號(hào)，excel字符串拼接這個(gè)問(wèn)題很多朋友還不知道，今天小六來(lái)為大家解答以上的問(wèn)題，現(xiàn)在讓我們一起來(lái)看看吧！

1、設(shè)數(shù)據(jù)如圖:將公式 =IF(B2=B1,"",B2) 復(fù)制后粘貼到"C2"單元格;將公式 =IF(C2="","",IF(SUM(C2:C8)=C2,A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8,IF(SUM(C2:C7)=C2,A2&","&A3&","&A4&","&A5&","&A6&","&A7,IF(SUM(C2:C6)=C2,A2&","&A3&","&A4&","&A5&","&A6,IF(SUM(C2:C5)=C2,A2&","&A3&","&A4&","&A5,IF(SUM(C2:C4)=C2,A2&","&A3&","&A4,IF(SUM(C2:C3)=C2,A2&","&A3,A2))))))) 復(fù)制后粘貼到"D2"單元格,將"C2:D2"二個(gè)單元格選中,對(duì)準(zhǔn)"D2"單元格右下角,光標(biāo)成"+"狀時(shí)雙擊(或拖下去),效果如圖:注意:一、用此方法必須對(duì)"B"列排序;二、如果同一分?jǐn)?shù)從數(shù)超過(guò)7人,可將公式 =IF(C2="","",IF(SUM(C2:C14)=C2,D2&","&A9&","&A10&","&A11&","&A12&","&A13&","&A14,IF(SUM(C2:C13)=C2,D2&","&A9&","&A10&","&A11&","&A12&","&A13,IF(SUM(C2:C12)=C2,D2&","&A9&","&A10&","&A11&","&A12,IF(SUM(C2:C114)=C2,D2&","&A9&","&A10&","&A11,IF(SUM(C2:C10)=C2,D2&","&A9&","&A10,IF(SUM(C2:C9)=C2,D2&","&A9,"")))))))復(fù)制后粘貼到"E2"單元格,將公式雙擊下去,如圖:。

本文分享完畢，希望對(duì)大家有所幫助。

標(biāo)簽：