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

sunnyso

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

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

¤U¸ü (22 KB)

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)

¤U¸ü¦¸¼Æ: 10

2013-4-8 20:14

Hsieh

¦^´_ 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¦ì«ü¥¿

   

¤U¸ü (11.79 KB)

2013-4-9 09:03

sunnyso

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

Hsieh

¦^´_ 3# sunnyso
À³¸Ó¬O¨S¦³
´N¤Ö­Ó§PÂ_±ø¥ó§a
=OR(CHAR(CODE(A2))<>TEXT(A2,"@"),CODE(A2)>127)

ML089

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}

sunnyso

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

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

ANGELA

¦^´_ 5# ML089


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

ML089

¦^´_ 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)

ML089

¦^´_ 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

sunnyso

¦^´_ 9# ML089
冧
嘅
嗰
啲