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

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

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

¥»©«³Ì«á¥Ñ vackbin ©ó 2017-11-29 14:19 ½s¿è

½Ð°Ý¦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
Jack

RE: ¦X¨ÖÀx¦s®æ¦r¦ê¡A©¿²¤ªÅ¥ÕÄæ¦ì(¤w¸Ñ¨M)

¦^´_ 1# vackbin
Jack

TOP

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

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
Jack

TOP

«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,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ joblyc017 ©ó 2017-11-29 15:25 ½s¿è

¦^´_ 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
2017-11-29_151740.png
2017-11-29 15:22

TOP

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

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

TOP

¦^´_ 1# vackbin


   
2017-11-29_142859.png
2017-11-29 14:29

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD