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

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

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

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

¦^´_ 10# sunnyso


    ½Ð°Ý§A«ç¼Ë§ä¥X³o¨Ç¦r?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-5-8 14:39 ½s¿è

§Ú»{¬° ASCII CODE 0~255 ¬°³æ¦r¤¸¡A¨ä¥L¥H¥~³£ºÙ¬°Âù¦r¤¸¤ñ¸û²³æ
³æ¦r¤¸¯S©Ê LEFT()»PLEFTB()¨ú­ÈÀ³¸Ó¬Û¦P
¥Î =LEFTB(A2)<>LEFT(A2) ¨Ó§PÂ_TRUE¬°Âù¦r¤¸¡AFALSE¬°³æ¦r¤¸


©ó¹ê°È¤W¹B¥Î½d¨Ò
R3 ="氹¥J¿DA1?¡H"
¦³4­Ó¥þ«¬¦r¡A ª`·N "氹" ¯S§O¦r¤¸ LENB()=1

­pºâ¥þ«¬¦r¤½¦¡
=SUMPRODUCT(--(MID(R3,ROW(1:9),1)<>LEFTB(MID(R3,ROW(1:9),1))))
=4
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 16# ­ã´£³¡ªL

BIG5 ¨ç¼Æ±N¥b§Î¦r¤¸Âà´«¦¨¥þ§Î (Âù¦ì¤¸²Õ) ¦r¤¸
A2¬°¤@­Ó¦r¤¸±¡ªp§PÂ_¬O§_¬° ¥þ¦r«¬
¥Î  =BIG5(A2)=A2 ¨Ó§PÂ_¤]¬O¦n¤èªk¡A¦ý¤´»Ýª`·NªÅ¦r¤¸ "" ¤ÎªÅ®æªº§PÂ_
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-5-21 21:36 ½s¿è

¦^´_ 19# ­ã´£³¡ªL


    ÆgÆgÆg!
    ³oÀ³¸Ó¬O³Ð·s¤½¦¡

µù¸Ñ¤@¤U¡A¥H§K¤é«á­n§Ñ°O
B¡G¥þ«¬¦r¼Æ
S¡G¥b«¬¦r¼Æ
¢Ð¢°¡G=LEN(A1)+LENB(A1)-LENB(BIG5(A1))
¢Ð¢°¡G=B+S + B*2+S - (B*2 + S*2)
¢Ð¢°¡G=B + (B*2+S*2) - (B*2 + S*2)
¢Ð¢°¡G=B
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 21# Bodhidharma

¨S¿ù¡A§Aªº»¡©ú¤ñ¸û¹ï¡A­«ÂI´N¬O X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD