ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦X¨ÖÀx¦s®æ¦r¦ê¡A©¿²¤ªÅ¥ÕÄæ¦ì

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

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD