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

[µo°Ý] ¦p¦ó§PÂ_¬O§_ ¥þ§Î¦r?

[µo°Ý] ¦p¦ó§PÂ_¬O§_ ¥þ§Î¦r?

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-4-8 20:17 ½s¿è

¦p¦ó§PÂ_¬O§_ ¥þ§Î¦r? ¦³¨S¦³¥Î VBA ©M¤£¥ÎVBAªº¤èªk.  ÁÂÁÂ

¥Î=CODE() ¹ï"氹" ¦r ¨S¦³¥Î

Capture.JPG
2013-4-8 20:14
  1. ¦r        is¥þ§Î
  2. 氹        TRUE
  3. ¥J        TRUE
  4. ¿D        TRUE
  5. A        FALSE
  6. 1        FALSE
  7. ¢°        TRUE
  8. ?        FALSE
  9. ¡H        TRUE
  10. .        FALSE
  11. ¡C        TRUE
½Æ»s¥N½X
q.rar (6.22 KB)
ss

¦^´_ 1# sunnyso
¤@¯ë¦Ó¨¥¡A¦r¦êªº¦r½X¹ïÀ³¦r¤¸»PÅã¥Ü¦r¦ê¤£¦P®É(¦pÁcÅé¨t²ÎÅã¥Ü²Åé¤å¦r)
氹(£|£³)¦r¨Ï¥ÎCODE¨ç¼Æ¨ú±oªº¦r¤¸½X¬O63
63¹ïÀ³ªº¦r¦ê¬O?(°Ý¸¹)
¥H¦¹¬°¨Ì¾Ú¡AÅã¥Ü»P¹ïÀ³¤£¦P«hÄݩ󤤤å¦r¬°¥þ«¬¦r
¤£¦b0~127¦r½Xªí¤ºªº¤å¦r¤]ÄÝ©ó¥þ«¬¦r(128~255¬O§_ÄÝ©ó¥þ«¬?)
±o¨ìªº³W«h
B2=OR(CHAR(CODE(A2))<>TEXT(A2,"@"),CODE(A2)<0,CODE(A2)>127)
¬O§_ÁÙ¦³¨ä¥L³W«hÄÝ©ó¥þ«¬¡AÁٽЦU¦ì«ü¥¿

   
¥¼©R¦W.png
2013-4-9 09:03
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂ,  code() ·|¤p©ó0 ¶Ü¡H­Y·|¤°»ò±¡ªp¡H
ss

TOP

¦^´_ 3# sunnyso
À³¸Ó¬O¨S¦³
´N¤Ö­Ó§PÂ_±ø¥ó§a
=OR(CHAR(CODE(A2))<>TEXT(A2,"@"),CODE(A2)>127)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ASCII CODE ¤£¬O<=255 ?

¥þ¦r«¬À³¸Ó¬O«ü»¡Âù¤¸¦r«¬
¤@¯ë¥Î LENB() ¨Ó§PÂ_¬O§_¬°¥þ¦r«¬

¦ý 氹 ­Ó¦r¥Î LENB("氹") = 1¡A ³o¥i¥´¯}¥H©¹ªº·Qªk

¥Ñ¤U¦C¨â¦¡¬Ý¥XEXCEL³B²z¤èªk¤]¥X²{¤£¤@­P©Ê¡A"氹" ¥ÎMIDB¥X²{2ªº¦r¤¸¡A¥ÎLENB«ü¥X²{1­Ó¦r¤¸
=MIDB("氹123",{1,2,3,4,5,6},1) ={" "," ","1","2","3",""}
=LENB(MID("氹123",{1,2,3,4,5,6},1)) ={1,1,1,1,0,0}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

§Ú¥»¨Ó¤]¬O¥Î >255 ¨Ó§PÂ_, doublebyte¦r

¥¼ª¾¬O§_ Excel ªº bug
ss

TOP

¦^´_ 5# ML089


    ¦³«Ü¦h¥j¦r©Î¤Ö¥Îªº¦r¥Îcode()¬d¸ß·|±o¨ì63ªº¦r,¥Îlenb()¬d³£·|±o¨ì1

TOP

¦^´_ 4# Hsieh

    =OR(CHAR(CODE(A2))<>TEXT(A2,"@"),CODE(A2)>127)

³æ¦r¤¸´ú¸Õ²Ä¤@¦r¤¸¬O§_¬°¥þ¦r«¬
=OR(CHAR(CODE(A2))<>A2$"",LENB(A2)=2)

¦h¦r¤¸´ú¸Õ²Ä¤@¦r¤¸¬O§_¬°¥þ¦r«¬
¦pªG¥H CODE() ¨ú²Ä¤@¦r¤§¯S©Ê¡A¥i¥H¥Î LEFT() ¨Ó¤Ç°t
=OR(CHAR(CODE(A2))<>LEFT(A2),LENB(LEFT(A2))=2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ANGELA

©Ò¥H¥þ§Î¦rªº§PÂ_´NÅܱo§ó½ÆÂø

¼Ó¥D¤]¤Ó¼F®`¡A§ä¥X 氹 ¦r¡ALENB()=1

¤£ª¾­þ¸Ì¥i¥H§ä¥X³o¨Ç¦r½X¡A¦A´ú¸Õ­þ¨Ç¦r½XLENB()=1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089



ss

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD