§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B

parker

½Ð°Ý¹³¤U¦C¦³¤À®æ²Å¸¹¦b¦P¤@Äæ¡A§Ú·Q¤ñ¹ï¤£¦PÄæ¦ì¬O§_¦³¬Û¦P(­«ÂÐ)ªº¨Ã¥B­«ÂЪº¥iÅܦ¨¬õ¦â(§Oªº¦â¤]¥i¥H)³oºØ¤½¦¡­n¦p¦ó¼g??ÁÂÁÂ

  C1,C2,C3,C4,C5...................
  C5,C6,C7,C8..............
  R5,R6,R7,R8.................
  R12,R6,R17,R18...............
.
.
.
.

parker

¦^´_ 2# p212
½ÐÀ°¦£¬ÝªþÀɪº¤å¥ó,³o¬O§Ú­Ì­n«ØÀɪºBOMªí§Ú¥u§T¨ú¤Ö³¡¥÷¡A¶À¦âÄæ¦ì(¦ì¸m)¬O§Ú·Q­n¦Û°Ê¤ñ¹ï¬O§_¦³­«½Æ¤å¦r¡A¦]¬°¦³¤À¹j²Å¸¹©Ò¥H¤£ª¾¤½¦¡­n¦p¦ó¼g¡Cºñ¦âÄæ¦ì(¼Æ¶q)¬O§Ú§Æ±æ¦Û°Êºâ¥X¶À¦âÄæ¦ì(¦ì¸m)¦³´X­Ó¹s¥ó¡A©Ò¥H¤£ª¾¬O§_¦³¤½¦¡¥i§iª¾??

ÁÂÁÂ

parker

¦^´_ 4# p212


    ·PÁ¤F½Ð°Ý¦³¨º¨Ç®Ñ¥»©Îºô¯¸¦³¦b±Ðexcelªº³o¨Ç¤½¦¡¼gªk???§Ú·Q­n¦n¦n¾Ç²ß¬ã¨s¤@¤U.

parker

¦^´_ 4# p212


    P212¤j¼w;
                   §Ú­è­èkey¤J¤½¦¡¦bC2Äæ¦ì¸ÕÅçµoı¤£¦æ,ÅܪťյL¥ô¦ó¼Æ¦r???¬O§Ú¤½¦¡key¿ùÄæ¦ì¤F¶Ü??


ÁÂÁÂ

parker

¦^´_ 8# p212


    §Ú§ä¨ì¤F,­ì¨Ó§Ú¦h¥´­ÓªÅ®æ,¥H«á§Ú­n±`¨Ó³o¬Ý¬Ýµ{¦¡½d¨Ò¼W¥[¥\¤O

ÁÂÁ¤F.

parker

¦^´_ 9# parker


    ¥t¤@­Ó°ÝÃD¶À¦â¨º¤@Äæ(¦ì¸m)­n¦p¦ó¤ñ¹ï¦]¸Ó¦³ÂIÃø«×¤£ª¾¦³°ª¤â¥i¸Ñµª¶Ü??

parker

¦^´_ 4# p212


    p212;
             ÁÂÁ§A¸Ñµª,¯à¥Î©TµM«Ü¦n¦ý§Ú·Q¤F¸Ñ¤½¦¡ªº§t·N³o¼Ë¤~¥i¥H¤é·s¶V·s¤£Â_¶i¨B©Ò¥H§Ú¦³¤U¦C°ÝÃD
1¡BLEN(D2)¡G­pºâD2Àx¦s®æ­ì¦³¦r¼Æ-------
ask:¬°¦ó­n¥ýºâÀx¦s®æ­ì¦³¦r¼Æ??D2Àx¦s®æ¬O"U1"©Î"C2,C3,C4,C5"³o¥i¥Hºâ¶Ü??¨º¬°¦ó­n¤U¦C²Ä2³¡"§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£
¤¤Â_"

2¡BSUBSTITUTE(D2,",","")¡G§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_

ask:­Y¤£§R°£¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_¬O§_¥iª½±µ°õ¦æ¤U¦C²Ä3¨B

3¡BLEN(SUBSTITUTE(D2,",",""))¡G­pºâ§R°£D2Àx¦s®æ¤¤ªº³r¸¹«á³sÄò¦r¦êªº¦r¼Æ

ask:¤W¦C³o¨Ç¤½¦¡¬O©T©wªº¨BÆJ¶Ü??ÁÙ¬O¥i¥H¹³C»y¨¥¤@¼Ë¦³»yªk©Î¥i²¤Æµ{¦¡??

ÁÂÁÂ

parker

¦^´_ 12# p212


    ¨ü±Ð¨ü±Ð,¤F¸Ñ¤F
ÁÂÁÂ