- ©«¤l
- 63
- ¥DÃD
- 34
- ºëµØ
- 0
- ¿n¤À
- 103
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-5
- ³Ì«áµn¿ý
- 2024-10-17
|
¦^´_ 2# Bodhidharma
ÁÂÁÂBodhidharma ªº¦^µª¡A§Ú¤]¬O¥ÎMID¨ç¼Æ¨ú±o§Únªº¸ê°T¡A¥H¤U¬O§Ú¦Û¤v¼gªº¨ç¼Æ¡A¦³ÂI¤¾ªø¡A¤£¹L¬ù8¦¨¥H¤W¥i¥H¹F¦¨¥Ø¼Ð
B1=MID(A1,FIND("¡G",A1)+1,3)
C1==MID(A1,MAX(IF(ISERR(FIND({"¿¤","¥«"},A1)),0,FIND({"¿¤","¥«"},A1)))-2,3)&MID(A1,MAX(IF(ISERR(FIND({"¶m","Âí","¥«","°Ï","§ø"},A1)),0,FIND({"¶m","Âí","¥«","°Ï","§ø"},A)))-2,3)
C1ªº¨ç¼Æ´X¥G¥i¥H¹F¦¨§Úªº»Ý¨D¡A¥i¬O¦pªG§ÚªºA1Äæ¬O¥u¦³"¾Ç®Õ¦a§}¡G"©Î¬O"¾Ç®Õ¦a§}¡G407 ¥x¤¤¥«¤åµØ¸ô100¸¹"´N·|¥X²{#VALUE!ªº¿ù»~°T®§¡A¦³ªk¥i¸Ñ¶Ü¡HÁÂÁ¡C |
|