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

[µo°Ý] §ó§ï½s¸¹

[µo°Ý] §ó§ï½s¸¹

«e½ú

1)¦p¦ó§Ö³t§ó§ï½s¸¹?

2)¥þ§Î¦rÅé§ï¦¨¥b§Î¦rÅé, ¨Ï¥Î¤FASC¨ç¼Æ,¨Ì¤£¥i¥H,¦³¤°»ò¤èªk

½Ð¬ÝªþÀÉ Number.rar (1.75 KB)

¦^´_ 1# Qin

1.B3=LEFT(A3,1)&TEXT(RIGHT(A3,4)+9,"0000")
   
2.=ASC(F3)
   ¥i¥Hªº ¦A¸Õ¸Õ¬Ý

TOP

¦^´_ 1# Qin


    ¥þ§Î¦r¤¤¦³ªÅ®æ
=SUBSTITUTE(ASC(F3)," ",)

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD