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

½Ð°Ý¤@¤U¤j¤j¬y¤ô¸¹¬°¤°»ò¤£¥i¥H¥Î

½Ð°Ý¤@¤U¤j¤j¬y¤ô¸¹¬°¤°»ò¤£¥i¥H¥Î

A1=GAC03000001
A2=LEFT(MID(A1,1,3))&MID(A1,4,255)+1
¥X¨Óªº­È¬OG3000002
¬°¤°»ò¤£¬OGAC03000002

§Ú¸Õ³o¦bB1Àx¦s®æ¥´ GAC
B2=MID(A1,1,3)
¥X¨Óªº­È¤]¬OGAC
celina710828

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-16 17:24 ½s¿è

¦^´_ 1# celina710828
½Ð¸Õ¸Õ¬Ý
1¡BA2Àx¦s®æ¿é¤J
=LEFT(A1,4)&RIGHT(A1,LEN(A1)-4)+1
2¡BA3Àx¦s®æ¤§«á½Æ»sA2Àx¦s®æ¤§²Õ¦X¨ç¼Æ(©¹¤U©Ô)

TOP

¦^´_ 1# celina710828
A2=MID(A1,1,3)&MID(A1,4,255)+1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥ýLEN(A1)¬Ý¬Ý¦r¼Æ¬O§_¬Û²Å,
¬O§_¦³ÁôÂ䧪ťÕ
¦A¬Ý¬ÝÀx¦s®æ¬O§_¦³Åã¥Ü¤å¦rªº°ÝÃD
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_  celina710828
A2=MID(A1,1,3)&MID(A1,4,255)+1
Hsieh µoªí©ó 2013-1-16 17:37

¸Õ¥Î¤F¡uHsieh¡v¤j¤jªº¼Ò¦¡,µo²{A2¥X²{ªº®ÄªG¬°¡uGAC3000002¡v¡A¸ÕµÛ§ó§ï¬°=MID(A1,1,¢³)&MID(A1,4,255)+1§Y¥i§¹¦¨¼Ò¦¡

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD