¦X¨ÖÀx¦s®æ¦r¦ê¡A©¿²¤ªÅ¥ÕÄæ¦ì
- ©«¤l
- 97
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 158
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2010-9-12
- ³Ì«áµn¿ý
- 2019-8-29
|
1. ªÅ¥Õ¸ê®ÆÄæ¦ìY¬°ªÅ¡A
=CONCATENATE(IF(A1<>"",A1&",",""),IF(B1<>"",B1&",",""),IF(C1<>"",C1&",",""))
¦b¥h±¼³Ì«á¤@Ó¡§,"
2.=TRIM(CONCATENATE(A1," ",B1,," ",C1," ",D1," ",E1," ",F1," ", G1," ",H1))
2. ±N¸ê®Æ½Æ»s¶K¤WÈ
3. °µ§¹¦b¬d§ä¨ú¥N " "-->"," |
|
lionliu
|
|
|
|
|