¬Ý°_¨Ó¤@¼Ë,¬°¤°»ò¨ç¼Æ¤ñ¹ï·|¤£¤@¼Ë?
- ©«¤l
- 100
- ¥DÃD
- 37
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-8-11
- ³Ì«áµn¿ý
- 2024-3-12
|
¬Ý°_¨Ó¤@¼Ë,¬°¤°»ò¨ç¼Æ¤ñ¹ï·|¤£¤@¼Ë?
¥»©«³Ì«á¥Ñ VANESSA ©ó 2013-12-11 12:05 ½s¿è
½Ð°ÝªþÀɪºA1©MB1 ¬Ý°_¨Ó¤@¼Ë,¬°¤°»ò§Ú¦bC1¥Î¨ç¼Æ¤ñ¹ï(A1=B1)µ²ªG³ºµM¥X²{"FALSE',§Ún¦p¦óÅýA1ªº¸ê®Æ©MB1¬Û¦P?
A1 B1 C1
CC80607 CC80607 =A1=B1µ²ªG"FALSE" |
-
-
Book1.zip
(5.7 KB)
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 7# Hsieh
·PÁ¶Wª©Hsieh«ü¾É¡I
©Ó1#¤§ì°Ý (µLªkª½±µ¥ÎTRIM©ÎCLEAN¨ç¼Æ²¾°£ªÅ¥Õ¦r¤¸ªÌ)
1¡B¹ï©ó©Ò¦³¨ã¬Û¦P¤å¦r¤º®eªº¨âÓÀx¦s®æ¦Ó¨¥¡A¦]¡u¦r«¬½X¡vªº¼vÅT¡A¨ä¦r¤¸ªø«×®t§O¬Ò¶È®t¡u1¡vÓ¦r¤¸¡H
2¡B¹ï©óÀx¦s®æA1»PÀx¦s®æB1¤§³Ì¥kºÝY¤À§O§t¦³¤£¦PӼƪºªÅ¥Õ¦r¤¸(¥~ªíµLªkª½±µ¿ëÃÑ¥X¨Óªº¡BµLªkª½±µ¥ÎTRIM©ÎCLEAN¨ç¼Æ²¾°£ªÅ¥Õ¦r¤¸ªÌ)¡A½Ð±Ð¦p¦óקï²Õ¦X¤½¦¡¥H«K²M°£³o¨ÇªÅ¥Õ¦r¤¸¡H
ÁÂÁ¡I |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2013-12-11 14:38 ½s¿è
¦^´_ 3# VANESSA
¨ä¹ê¬O "¦r«¬½X" ªºªø«×¤£¤@¼Ë¡A¨Æ¹ê¤W A1 »P B1 ³£¥u¦³¤CÓ¦r¤¸¡C
¬Ý¹L¥H¤U¹Ï¥Ü«Kª¾¡A§Ú¤]¦P®É¥Î VBA ¨Ó°µ¹ê»Ú¤ñ¹ï¡G
|
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¦^´_ 3# VANESSA
¤£ª¾¬°¦ó³s¨Ï¥Î
=SUBSTITUTE(A1,CHAR(160),"")
©Î
=SUBSTITUTE(TRIM(A1),CHAR(160),"")
¤]µLªk²¾°£Àx¦s®æA1¦h¥XªºªÅ¥Õ¦r¤¸
¦³½Ð¦U¦ì¥ý¶i½ç±Ð |
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 37
- ºëµØ
- 0
- ¿n¤À
- 139
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-8-11
- ³Ì«áµn¿ý
- 2024-3-12
|
¤Ó·PÁ±z¤F,¯uªº,¦h¤F¤@½X,¦ý¬O¬°¤°»ò§Ú¥ÎTRIM(A1),¨S¿ìªk§R±¼ ³Ì¥kºÝ¦h1Ó¡uªÅ¥Õ¡v¦r¤¸
? |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-11 13:27 ½s¿è
¦^´_ 1# VANESSA
Àx¦s®æA1»PÀx¦s®æB1¤º®e¤£¦P
¥ÎLEN¨ç¼Æ¥i¬Ý¥X
LEN(A1)=8
LEN(B1)=7
Àx¦s®æA1¤º®e³Ì¥kºÝ¦h1Ó¡uªÅ¥Õ¡v¦r¤¸
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|