- 帖子
- 97
- 主題
- 26
- 精華
- 0
- 積分
- 158
- 點名
- 0
- 作業系統
- windows
- 軟體版本
- office2010
- 閱讀權限
- 20
- 性別
- 男
- 來自
- taichung
- 註冊時間
- 2010-9-12
- 最後登錄
- 2019-8-29
|
1. 空白資料欄位若為空，
=CONCATENATE(IF(A1<>"",A1&",",""),IF(B1<>"",B1&",",""),IF(C1<>"",C1&",",""))
在去掉最後一個“,"
2.=TRIM(CONCATENATE(A1," ",B1,," ",C1," ",D1," ",E1," ",F1," ", G1," ",H1))
2. 將資料複製貼上值
3. 做完在查找取代 " "-->"," |
|
發表於 2017-12-8 10:25
| 