ªð¦^¦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)

=LEFT(CLEAN(H7),9)

TOP

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD