- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 7# s10002096
°ª¶¯¿¤¤jªÀ¶m(OR¥«ORÂí)¤¤µØ¸ô8¤§12¸¹
n¦p¦ó§â¶m¥«Âí§ï¦¨°Ï©O¡H
¶m¥«Âín§ï¦¨°Ï,¥i¥Î°ò¥»¾Þ§@ªº´À´«, CTRL+H Áä,¥þ³¡¨ú¥N,¾Þ§@¤T¦¸
¤£«Øij¥Î¨ç¼Æ.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"¶m","°Ï"),"¥«","°Ï"),"Âí","°Ï")
ÁÙ¦³ISERROR³oÓ¨ç¼Æ«ç»ò¨Ï¥Î§r¡A¤£ºÞ«ç»ò®M¶i¤½¦¡¸Ì³£µLªk¥¿±`¹Bºâ
¯u±o«Ü·P¿E§A¦^µª¤F§Ú³o»ò¦hªº°ÝÃD¡I¡I:$
ISERROR¬O¥Î¨Ó´ú¸Õ¬O§_¨ç¼Æ¦³¿ù»~,·|¶Ç¦^TRUE ©Î FALSE,IF¨ç¼Æ®É±`·|¥Î¨ì.
¥i¦b½s¿è¦C¤¤§âISERROR(.........)¥Î·Æ¹«¤Ï¥Õ,¦A«öf9,´N¥i¥Hª¾¹D³o¬q¨ç¼Æªº¹B§@. |
|