EXCEL ¼Æ¦rÂà¤é´Á¦b¿z¿ï¤ë¥÷
- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- Window7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2013-12-5
- ³Ì«áµn¿ý
- 2013-12-5
|
EXCEL ¼Æ¦rÂà¤é´Á¦b¿z¿ï¤ë¥÷
·Q±N¤@¯ë¼Æ¦rÂà´«¦¨¤é´Á¡A¦AÂǥѤé´Á¥h°µ¿z¿ï¤ë¥÷¡A¦ý¼Æ¦rÂà¤ë¥÷³¡¤À¥i¥H¥ÎTEXT¨Ó°µ¡A¦ý¨ì¤Fn¿z¿ï¦¨¤ë¥÷´N¤S¤£¯à¥ÎTEXT¤F¡A¤£ª¾¹D¦U¦ì¥i§_¦³¦nªº«Øij?¨ì¾¤é | °lÂܤë¥÷ | 1021118 | 11¤ë¥÷ | 1021118 | 11¤ë¥÷ | 1021113 | 11¤ë¥÷ | 1021111 | 11¤ë¥÷ | 1021101 | 11¤ë¥÷ | 1021101 | 11¤ë¥÷ | 1021101 | 11¤ë¥÷ | 1021201 | 12¤ë¥÷ | 1021101 | 11¤ë¥÷ | 1021121 | 11¤ë¥÷ | 1021122 | 11¤ë¥÷ | 1021202 | 12¤ë¥÷ |
|
|
|
|
|
|
|
- ©«¤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
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¦^´_ 1# mtsyoyo
Àx¦s®æB2¿é¤J
=MID(A2,4,2)&"¤ë¥÷"
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 1# mtsyoyo
«Øij¤ë¥÷Âର¼Æ¦r«¬
B2 =IF(a2="","",--MID(A2,4,2))
¦V¤U½Æ»s |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 605
- ¥DÃD
- 92
- ºëµØ
- 0
- ¿n¤À
- 648
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- macau
- µù¥U®É¶¡
- 2013-4-5
- ³Ì«áµn¿ý
- 2019-2-10
![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![¦n¾Ç¨Dª¾¾±³¹ ¦n¾Ç¨Dª¾¾±³¹](images/common/medal2.gif)
|
¦^´_ 1# mtsyoyo
99¦~1¤ë1¤é¦p¦óªí¥Ü©O?
9911
or
99011
or
990101
or
0990101
or
...... |
|
ss
|
|
|
|
|
- ©«¤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
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-5 13:54 ½s¿è
¦^´_ 4# sunnyso
¤@¯ë¤½¥q¦æ¸¹¹ï¡u¥Á°ê¡v¾ä±Ä¤C¦ì½Xªí¥Ü¡A¥Á°ê99¦~1¤ë1¤é§Y¥H¡u0990101¡vªí¥Ü¡A¬GÀ³µLsunnyso¤jªºÅU¼{¡C
½Ð°Ñ¦Ò¡I |
|
|
|
|
|
|