ÃøÃD!!! ¶Ç¦^Àx¦s®æ¤º®e¡A¥Ñ¥k¦Ü¥ª
- ©«¤l
- 8
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ·s¥_¥«
- µù¥U®É¶¡
- 2013-9-9
- ³Ì«áµn¿ý
- 2015-7-26
|
Y¤£¨Ï¥Î¥¨¶°ªº±¡ªp¤U¡A¥i¾î¦V±N¨CÓÀx¦s®æªº¤º®e¦ê°_¨Ó¡A¦A¨ú³Ì¥kÃ䪺¦r¤¸¡AÀ³¸Ó´N¬O³Ì°ªª©¦¸¤F¡C
G2Àx¦s®æªº¤º®eÀ³¸Ó¬O"=RIGHT(CONCATENATE(B2,C2,D2,E2,F2),1)"
PS.
1¡BCONCATENATE()³Ì¦h¥i¦³30Ӥ޼ơA¬G³Ì¦h¥i§P©w¾î¦V30ÓÀx¦s®æªº¤º®e¡C
2¡BCONCATENATE()¤]¥i§ï¥Î"&"¨Ó´À¥N¡A¨Ò¦p¡G"=RIGHT(B2 & C2 & D2 & E2 & F2,1)"¡]&«e«á¥i¥H¤£»ÝªÅ®æ¡^
¥H¤W¬O¤p§Ìªº©å¨£¡AY¦³¨ä¥¦¿ìªk¡A¤]½Ð¤£§[«ü±Ð¡AÁÂÁ¡C |
|
George Ma
|
|
|
|
|