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

[µo°Ý] ©_©Çªº®æ¦¡

[µo°Ý] ©_©Çªº®æ¦¡

½Ð±Ð¤@¤U¦U¦ì¤j¤j
¹J¨ì¤@ºØ©_©Çªº®æ¦¡
Àɮ׸̧ڥÎleft§ì9¦ì¡Aµ²ªG¥u¥X²{8¦ì
½Ð°Ý¬O¤°»ò­ì¦]¡A¦³¿ìªk¼gµ{¦¡§R°£¶Ü¡H
test.zip (1.38 KB)

­ì¨Ó¬OµLªk¦C¦Lªº¦r¤¸ªº°ÝÃD£¬

TOP

·PÁÂ~~§Úªº°ÝÃD¤w¸g¸Ñ¨M¤F!!!!

TOP

=LEFT(CLEAN(H7),9)

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD