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

[µo°Ý] ¤å¦r®æ¦¡¦p¦ó§ïÅܦ¨¼Æ­È®æ¦¡©O

[µo°Ý] ¤å¦r®æ¦¡¦p¦ó§ïÅܦ¨¼Æ­È®æ¦¡©O

¥»©«³Ì«á¥Ñ vinejason ©ó 2016-8-4 16:27 ½s¿è

ªB¤Í­Ì¥­¦w
¹J¨ì¤@­Ó«Ü¤£¸Ñªº°ÝÃD
¥Îvalue¨ç¼Æ ±ý±N¤å¦r®æ¦¡Åܬ°¼Æ¦r®æ¦¡
¥i¬O¥X²{¿ù»~
½Ð±Ð¥i¥H«ç»ò°µ©O ?
¥ýÁÂÁ±z­Ì
µL¤îºÉªº§V¤O¤W¶i

¦^´_ 1# vinejason


    ¬ÝµL
¦³Àɮ׶Ü

TOP

¦^´_  vinejason


    ¬ÝµL
¦³Àɮ׶Ü
popomilk µoªí©ó 2016-8-4 16:36


½Ð¬ÝªþÀÉ

Book1.rar (6.7 KB)

µL¤îºÉªº§V¤O¤W¶i

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2016-8-4 17:00 ½s¿è
½Ð¬ÝªþÀÉ
vinejason µoªí©ó 2016-8-4 16:44



    °Ý°ÝÃD½Ð¾¨¥i¯àÁ¿²M·¡»¡©ú¥Õ¦Aªþ¤WÀÉ®×.....
   
    ¤å¦r«á­±³£¦³«D¦C¦L¦r¤¸
    ¥i¥Îlen()´úªø«×¥i¬Ý¥X¡A¹ê´ú¥i¥H¥Îclean()²M°£(¤£¬O©Ò¦³¦r¤¸³£¯à¥Î clean¨ç¼Æ²M°£)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2016-8-4 17:12 ½s¿è

¦^´_ 1# vinejason
¡u¤å¡vÂà¡u¼Æ¡v
Àx¦s®æD2¿é¤J
=--CLEAN(A2)
©Î
=VALUE(CLEAN(A2))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 4# KCC

¤£¦n·N«ä ! §Ú·|§ï¶iªº
ÁÂÁ±z
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD