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

¬Ý°_¨Ó¤@¼Ë,¬°¤°»ò¨ç¼Æ¤ñ¹ï·|¤£¤@¼Ë?

¬Ý°_¨Ó¤@¼Ë,¬°¤°»ò¨ç¼Æ¤ñ¹ï·|¤£¤@¼Ë?

¥»©«³Ì«á¥Ñ 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)

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

TOP

¦^´_ 4# p212

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# VANESSA
§Ú¥Î´M§ä/¨ú¥Nªº¤èªk¡A¥i¥H§R°£¦h¾lªºªÅ¥Õ¦r¤¸

¤èªk¡G¿ï¨úA1 Àx¦s®æ¡A«ö ctrl+F¡A¦b´M§ä¤Î¨ú¥Nµøµ¡ªº´M§ä¥Ø¼ÐÄæ¦ì¡A¥ý«ö Alt Á䤣­n©ñ±¼¡A¦A¿é¤J160¡A¤§«á¿ï¨ú¥N¼ÐÅÒ¡Aª½±µ«ö¨ú¥NÁä¡A§Y¥i§R°£ªÅ¥Õ¦r¤¸

¥H¤Wµ¹±z°Ñ¦Ò

TOP

¥»©«³Ì«á¥Ñ 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

TOP

¦^´_ 3# VANESSA
¤£ª¾¬°¦ó³s¨Ï¥Î
=SUBSTITUTE(A1,CHAR(160),"")
©Î
=SUBSTITUTE(TRIM(A1),CHAR(160),"")
¤]µLªk²¾°£Àx¦s®æA1¦h¥XªºªÅ¥Õ¦r¤¸
¦³½Ð¦U¦ì¥ý¶i½ç±Ð

TOP

¤Ó·PÁ±z¤F,¯uªº,¦h¤F¤@½X,¦ý¬O¬°¤°»ò§Ú¥ÎTRIM(A1),¨S¿ìªk§R±¼ ³Ì¥kºÝ¦h1­Ó¡uªÅ¥Õ¡v¦r¤¸
?

TOP

¥»©«³Ì«á¥Ñ 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

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD