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

vackbin

½Ð°Ý¦U¦ì¤j¤j..

§Ú¦³¸ê®Æ¶·±N10­ÓÄæ¦ì¤¤ªº¦r¦ê¦X¨Ö¡A¨Ã¥H"³r¸¹¡A"¹j¶}¡C
¦]¬°¤£¬O¨C­ÓÄæ¦ì¦³¸ê®Æ¡A¦Ó¥BªÅÄæ¦ì¤£¬O©T©wªº¡A©Ò¥H±N¥X²{³\¦h"¡A"¡C¦p¤U©Ò¥Ü¡C
½Ð¤j¤jÀ°¦£¤@¤U¡A¦³¤°»ò¤è¦¡¯à§ïµ½¡CÁÂÁÂ~
¸ê®Æ:
    ³Â»¶ ®a±Ú EXCEL  _ ¤@¯ë°Ï _ _ _ VACK _ _ BIN_ ¨D_ _ _ _±Ï _ _¤¤   (¤U©³½u "_" ¬OªÅ¥ÕÄæ¦ìªº·N«ä)
­Y¨Ï¥Î"&"+"¡A" ¦X¨Ö«á·|Åܦ¨...
   ³Â»¶¡A®a±Ú¡AEXCEL¡A¡A¤@¯ë°Ï¡A¡A¡AVACK ¡A¡A BIN¡A¨D¡A¡A¡A±Ï¡A¡A¤¤
§Æ±æªºµ²ªG¬O...
  ³Â»¶¡A®a±Ú¡AEXCEL¡A¤@¯ë°Ï¡AVACK ¡A BIN¡A¨D¡A±Ï¡A¤¤   
¦]¬°¸ê®Æ¦³´X¤dµ§...§¹¥þµLªk¤â°Ê³B²z...... Orz

vackbin

¦^´_ 1# vackbin

lionliu

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  " "-->","

vackbin

To joblyc017 ¤j¤j..
Excel 2016 ¨S¾÷·|¨Ï¥Î³o»ò¥ý¶iªºª©¥»¡A§Ú¦A¸ò¤½¥q«Øij¡A¨þ¨þ~  
To hcm19522 ¤j¤j..
§Úªº¸ê®Æ¦³¤j¶q¼Æ¦r¡A®£µLªk¨Ï¥Î¡C@@a

ÁÙ¬O·PÁ¤j¤j´£¨Ñªº¤èªk¡C

hcm19522

«D¼Æ¦rÀY ¥BµLªk³rÂI°Ï¹j=PHONETIC(A1:P1)
R1¥k©Ô ,R1¬Oµ²ªG=IFERROR(IF(COLUMN(A1)=1,"",",")&INDEX(1:1,SMALL(IF($A1:$P1<>"",COLUMN($A1:$P1)),COLUMN(A1)))&S1,"")

joblyc017

¦^´_ 3# vackbin


    Excel 2016ª©¥»¡A¨Ã­q¾\Office 365 ¡A¦³ TEXTJOIN ¨ç¼Æ¥i¹F¨ì¦P¼Ëªº¦X¨Ö®ÄªG¡A¸Ôhttps://goo.gl/oFkkda

    «D2016ª©¥»¡A°£¤F¥H»²§UÄæ¦ì¦ê³s¡A©Î¥H¦Û­q¨ç¼Æ¡BVBA¦ê³s¥~¡A­Ó¤H¥Ø«e©|¥¼¦³§ó¦nªº¸Ñªk
    ¦Û­q¨ç¼Æ¥Ü½d¹Ï¡G

¤U¸ü (13 KB)

2017-11-29 15:22

vackbin

·PÁ joblyc017 ¤j¤j ªº"¥ú³t¦^ÂÐ"....
´ú¸Õ«á¡A¤½¦¡¥¿½T !!

¥u¬O³o¼Ë±N²£¥X¤Q´X­Ó"»²§U"Äæ¦ì¡A¦³¿ìªk¦X¨Ö¦¨¤@®æ¤½¦¡¶Ü?
ÁٽФj¤j±Ð¾Ç~~

joblyc017

¦^´_ 1# vackbin


   

¤U¸ü (14.9 KB)

2017-11-29 14:29