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

¦³Ãö§R°£ ( )¤º¸ê®Æ°ÝÃD

¦³Ãö§R°£ ( )¤º¸ê®Æ°ÝÃD

½Ð°Ý¦U¦ì¤j¤j¡G
¸Ó¦p¦ó§R°£( )¤ºªº¸ê®Æ?¸Ô¦pªþ¥ó Book1.rar (1.72 KB)

ÂIAÄæ
´M§ä ?(*) ¨ú¥N¤£­n³]©w
«ö¥þ³¡¨ú¥N ->§¹¦¨

TOP

=LEFT(A1,FIND(CHAR(10),A1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh


    ¤j¤j~ ½Ð±Ð¤@¤UCHAR()³o­Ó²[¼Æªº·N¸q
   §Ú¦³¥h¬d¹LCHAR³o­Ó¨ç¼Æªº»¡©ú,¦ý¤£¬Æ¤F¸Ñ¨ä·N«ä,¯à§_½Ð±Ð¤j¤j,¸Ó¨ç¼Æªº·N¸q.
  ¥H¤U¬OEXCEL »¡©ú¤º®e
  CHAR:¶Ç¦^¼Æ¦r«ü©wªº¦r¤¸¡C¨Ï¥Î CHAR ¥i¥H±N±z±q¨ä¥LÃþ«¬ªº¹q¸£Àɮפ¤¨ú±oªº¦r½X­¶¼Æ¦r¡AÂà´«¦¨¦r¤¸¡C
   A B
   ¤½¦¡ ±Ô­z (µ²ªG)
   =CHAR(65) Åã¥Ü¶°¦X¤¤ªº²Ä 65 ­Ó¦r¤¸ (A)
   =CHAR(33) Åã¥Ü¶°¦X¤¤ªº²Ä 33 ­Ó¦r¤¸ (!)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-1-27 10:56 ½s¿è

¦^´_ 4# hugh0620


    ASCII½s½X¤Q¶i¦ì¦r¤¸½X
¥t¥~¥i°Ñ¦ÒVBAªº¦r¤¸¶°0~127»¡©ú
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


    ÁÂÁ¤j¤j~ ³o¼Ë´N«Ü²M·¡¤F¸Ñ¾ã¦æ¨ç¼Æªº·N«ä¤F~
    1.FIND(CHAR(10),A1):¥ý§ä¨ìA1Àx¦s®æ¤¤"("ªº¦r¤¸¦ì¸m
   2.LEFT(Àx¦s®æ,FIND()),±q¥ªÃ䩹¥k¼Æ²Ä´X­Ó¦r¤¸ªº¦r¦ê

   ¦ý¬O¤j¤j~ §Ú«ÜµL²á¤S°µ¤F¤@¨Ç´ú¸Õ~ ¤S²£¥Í¤@¨Ç°ÝÃD
   A=FIND(CHAR(10),A1)-1 =7  
    B=FIND(CHAR(10),A1)=8
    ­Y®M¦bLEFT(A1,A)»PLEFT(A1,B)ªºµ²ªG¬O¤@¼Ëªº
   Q1:­Y¦r8­Ó¦r¤¸¬O"(",³o¼ËLEFT(A1,B)ªºµ²ªGÀ³¸Ó¬Oaos-1ps(
        ¦ýµ²ªG«o¬Oaos-1ps
    Q2:­Y¬OA1Àx¦s®æªº¸ê®Æ¬Oaos-1ps(¥[»ù)³o¼Ëªº³sÄò¸ê®Æ
       ¦Ó¤£¬OALT+ENTER±N¸ê®Æ¤Á¦¨¤W¤U¨â¦æ«¬ºA®É,
           ³o¼ËFIND(CHAR(10),A1)´N·|²£¥Í#VALUE!ªº±¡ªp
   ¥H¤W¨â­Ó°ÝÃD,½Ð¤j¤j±Ð¾É¤@¤U~

     (¤p§Ì¬O¨ººØ¹ï¤£¼ôªº¤u¨ã~ ´N·|ªF´ú¦è´ú~ ´£¥X¤@¨Ç°ÝÃD §Æ±æ¤j¤j¤£­nı±o·Ð)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

cw3076±z¦n¼F®`³á....ok¤F...¤§«e60´Xµ§¸ê®Æ...§Ú¥þ³¡¤@­Ó¤@­Ó§R...¥Î¤F±zªº¤èªk...§Ö¦n¦h...ths...^^

TOP

¦^´_ 6# hugh0620

CHAR(10) ¥i¥H»¡¬Oµ¥©ó «ö¤F ¡yAlt¡zÁä»P¡yEnter¡zÁä =>±j­¢´«¦C,§Y¦b¤@­ÓÀx¦s®æ¤¤,¿é¤J¤G¦C¸ê®Æ
±zªº²Ä¤G­Ó¸ÕÅç,¦]¬°ª½±µ¿é¤J,¨S¦³´«¦C,¬G¤½¦¡§ä¤£¨ì CHAR(10) ,·íµM¦^¶Ç #VALUE!
¦Ü©ó²Ä¤@­Ó°ÝÃD,¬O§_´î1
­Yµo°ÝªÌ¥Øªº¥u¬O­n«O¯d"("«eªº¸ê®Æ,¨º¥Î  =LEFT(A1,FIND(CHAR(10),A1)) ¤]µL¤£§´
¤£¹L,±z¥i¥H¿é¤J =len(B1),¥i¥Hµo²{¥¦¬O 8 ,¦]¬°¥¦¥]¬A¤F¥¼³Q¥h±¼ªºµL§Î"CHAR(10)" ==>¥i¥H¤Ä¿ï"Àx¦s®æ®æ¦¡"¤¤ªº"¦Û°Ê´«¦C",´N·|²{¨­¤F
©Ò¥H,­Yµo°ÝªÌªº­n¨D¬O,­n³s¦P´«¦C²Å¸¹¤]¤@¨Ö¤£¨£,¨º´N§ï¬° =LEFT(A1,FIND(CHAR(10),A1)-1)
§Æ±æ¥H¤W¸Ñ»¡,¦³¸Ñµª¨ì±zªº°ÝÃD
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 8# °¶ÔÐ


    Thank !! for your answer
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD