½Ð°Ý¤@¤U¤j¤j¬y¤ô¸¹¬°¤°»ò¤£¥i¥H¥Î
- ©«¤l
- 67
- ¥DÃD
- 21
- ºëµØ
- 0
- ¿n¤À
- 94
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2011-3-9
- ³Ì«áµn¿ý
- 2013-1-17
|
½Ð°Ý¤@¤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
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ 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©Ô) |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¥ýLEN(A1)¬Ý¬Ý¦r¼Æ¬O§_¬Û²Å,
¬O§_¦³ÁôÂ䧪ťÕ
¦A¬Ý¬ÝÀx¦s®æ¬O§_¦³Åã¥Ü¤å¦rªº°ÝÃD |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 33
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 125
- ÂI¦W
- 1
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-7
- ³Ì«áµn¿ý
- 2024-10-4
|
¦^´_ 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§¹¦¨¼Ò¦¡ |
|
|
|
|
|
|