ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦³¨S¦³¥i¥H·j´M¤@¦r¦ê¤¤ªº¯S©w¦rªº¨ç¼Æ

[µo°Ý] ½Ð°Ý¦³¨S¦³¥i¥H·j´M¤@¦r¦ê¤¤ªº¯S©w¦rªº¨ç¼Æ

½Ð°Ý¦U¦ì¹F¤H
¦³¨S¦³¹³VBA¸Ìlike¥\¯à¤@¼Ëªº¨ç¼Æ
¨Ò¦p:¤@¦r¦ê¤¤¦p¦³A´N¥Nªí¤@¸¹;¦p¬OB´N¥Nªí¤G¸¹¡A"A"¸ò"B"¨S¦³©T©w¦ì¸m

if(iserror(search("A",A2)*search("B",A2))=false,"½s¸¹1¸¹¤Î½s¸¹2¸¹",if(iserror(search("A",A2))=false,"½s¸¹1¸¹',if(iserror(search("B",A2))=false,"½s¸¹2¸¹',"³£¨S¦³")))

TOP

©êºp¡A¤W­z¶È¾A¥Î¦bVBA¤º
¦bExcel¤º«hSearch¬O¸û¬°¾A¦X¤ñ¹ïÀx¦s®æ¤ºªº¦r¦ê

TOP

¤]¥i¥H¥Î(¨ú¥N+¦r¼Æ­pºâ)ªº·§©À¥h¼g¡A
= if ( len ( replace(A1,"A",""))< len ( A1 ) , if ( len ( replace(A1,"B",""))< len ( A1 ) ,"1&2","1"),if ( len ( replace(A1,"B",""))< len ( A1 ) ,"2",""))

TOP

=IF(AND(ISNUMBER(SEARCH("A",A2)),ISNUMBER(SEARCH("B",A2))),"¤@¸¹&¤G¸¹",IF(ISNUMBER(SEARCH("A",A2)),"¤@¸¹",IF(ISNUMBER(SEARCH("B",A2)),"¤G¸¹","")))
ù

TOP

¸Õ¸Õ   SEARCH »P FIND
ù

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD