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

[µo°Ý] ½Ð°Ý:¨Ï¥Îright¨ç¼Æ¨ú2¦ì¼Æµ²ªG¬°­Ó¦ì¼Æ­È,¤Q¦ì¼Æªº0¦p¦óÁקK¥X²{¡]¤w¸Ñ¨M¡^

[µo°Ý] ½Ð°Ý:¨Ï¥Îright¨ç¼Æ¨ú2¦ì¼Æµ²ªG¬°­Ó¦ì¼Æ­È,¤Q¦ì¼Æªº0¦p¦óÁקK¥X²{¡]¤w¸Ñ¨M¡^

¥»©«³Ì«á¥Ñ onegirl0204 ©ó 2010-11-14 21:09 ½s¿è

°²³]A¦C§}¬°¤@³s¦êªº3¦ì¼Æ,¨Ò¦p:701,702,703.....(¥Nªí7¦~1¯Z,7¦~2¯Z,7¦~3¯Z........)
­ì¥»¸ê®Æ®w¿é¤J®É¥u¦³A¦Cªº¼Æ¦r,¦ý«á¨Ó¦]¬°¯S®í¥Î³~¥²¶·¥H´X¦~´X¯Zªº¤è¦¡§e²{,
¸ê®Æ¦³¤@¦Ê¦hµ§,¬G¥t¥~¥[¤F¤@¦C¥H=LEFT(C2,1)&" ¦~  "&RIGHT(C2,2)&" ¯Z"¨ç¼Æ«o¥X²{
7 ¦~ 01 ¯Z ªºµ²ªG,¥i§_§iª¾¦p¦ó­×¥¿¨ç¼Æ¤~·|¥X²{¡ã7 ¦~ 1 ¯Z¡HÁÂÁ¡I

©Ó»X¢±¼Ó¤Î¢³¼Óªº¨â¦ì«e½ú«ü±Ð¡A§Úªº°ÝÃD¤wÀò±o¸Ñ¨M¡A¦b¦¹·PÁ±z­Ì¡I

­t­t±o¥¿¡AÂন¼Æ¦r
=--LEFT(C2,1)" ¦~  "&--RIGHT(C2,2)&" ¯Z"
joviwang

TOP

¦^´_ 2# ¦Ñ®L


    «Ü¦n¥Î­C¡A¨ü±Ð¤F¡I¡I¡I
·s¤â¾Çexcel

TOP

¦^´_ 1# onegirl0204
VALUE ->  ±N¥Nªí¬Y¼Æ­Èªº¤å¦r¦r¦êÂà´«¦¨¼Æ¦r¸ê®Æ¡C
=LEFT(C2,1)&" ¦~  "&VALUE(RIGHT(C2,2))&" ¯Z"

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD