¦X¨ÖÀx¦s®æ¦r¦ê¡A©¿²¤ªÅ¥ÕÄæ¦ì
- ©«¤l
- 46
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- Win11
- ³nÅ骩¥»
- Office2013
- ¾\ŪÅv
- 0
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-13
- ³Ì«áµn¿ý
- 2024-3-26
|
¦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
|
|
|
|
|
- ©«¤l
- 111
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 156
- ÂI¦W
- 0
- §@·~¨t²Î
- Window
- ³nÅ骩¥»
- office 365
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2017-8-14
- ³Ì«áµn¿ý
- 2023-6-26
|
¦^´_ 1# vackbin
|
|
|
|
|
|
|
- ©«¤l
- 46
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- Win11
- ³nÅ骩¥»
- Office2013
- ¾\ŪÅv
- 0
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-13
- ³Ì«áµn¿ý
- 2024-3-26
|
·PÁ joblyc017 ¤j¤j ªº"¥ú³t¦^ÂÐ"....
´ú¸Õ«á¡A¤½¦¡¥¿½T !!
¥u¬O³o¼Ë±N²£¥X¤Q´XÓ"»²§U"Äæ¦ì¡A¦³¿ìªk¦X¨Ö¦¨¤@®æ¤½¦¡¶Ü?
ÁٽФj¤j±Ð¾Ç~~ |
|
Jack
|
|
|
|
|
- ©«¤l
- 111
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 156
- ÂI¦W
- 0
- §@·~¨t²Î
- Window
- ³nÅ骩¥»
- office 365
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2017-8-14
- ³Ì«áµn¿ý
- 2023-6-26
|
¥»©«³Ì«á¥Ñ 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
|
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-5
|
«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,"") |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 46
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- Win11
- ³nÅ骩¥»
- Office2013
- ¾\ŪÅv
- 0
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-13
- ³Ì«áµn¿ý
- 2024-3-26
|
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
|
|
|
|
|
- ©«¤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
|
|
|
|
|
- ©«¤l
- 46
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- Win11
- ³nÅ骩¥»
- Office2013
- ¾\ŪÅv
- 0
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-10-13
- ³Ì«áµn¿ý
- 2024-3-26
|
RE: ¦X¨ÖÀx¦s®æ¦r¦ê¡A©¿²¤ªÅ¥ÕÄæ¦ì(¤w¸Ñ¨M)
|
Jack
|
|
|
|
|