ªð¦^¦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

¸Õ¸Õ   SEARCH »P FIND
ù

TOP

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

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

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

TOP

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

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD