ªð¦^¦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 : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD