¥H¤½¦¡§@Ãþ¦ü¿z¿ïªº¥\¯à¡A¥i¥H¶Ü¡H

stl

Excel¤¤¡AA1 ¬O±q¨ä¥LÀÉ®×±o¥Xªº¤å¦r¡A¦³®É ABC  ¦³®É DEFG, ¦³®É HIJ , KLM, NOP, QRST, UVW µ¥7­Ó¯S©w²Õ¦X
§Ú·Q¦bB1¤¤Åã¥Ü»PA1 ¬Û¦Pªº¤å¦r¡A¦ý«Y·í¦b¬Y¦r¥X²{®É¡A´N¤£§@Åã¥Ü ©Î¥HªÅ¥Õ¥N´À¡A
§Y¬O·íA1 ¥X²{ABC®É¡AB1 ·Ó¥XABC
·íA1 ¥X²{ DEFG®É¡AB1 ´NªÅ¥Õ
·íA1 ¥X²{ HIJ ®É¡AB1 ¥ç³£¥XªÅ¥Õ
¥i¥H°µ±o¨ì¶Ü¡H

stl

Thanks for ¥H¤W¨â¦ì¡A§A­Ì¯u«Y¦n±j¡A¾¶§Ö´Nµª¨ì

toxin

B1=IF(A1="ABC","ABC",IF(A1="DEFG","",IF(A1="HIJ","","")))
¦³¨ä¥L±ø¥óªº¸Ü¥H¦¹Ãþ±À
¦ý¬O¥H
§Y¬O·íA1 ¥X²{ABC®É¡AB1 ·Ó¥XABC
·íA1 ¥X²{ DEFG®É¡AB1 ´NªÅ¥Õ
·íA1 ¥X²{ HIJ ®É¡AB1 ¥ç³£¥XªÅ¥Õ
³o¤T¦æ¬°±ø¥óªº¸Ü¬°¥u­n¼g=IF(A1="ABC","ABC","")´N°÷¤F§a

Hsieh

¦^´_ 1# stl


    =IF(ISERROR(MATCH(A1,{"ABC","DEFG","HIJ","KLM","NOP","QRST","UVW"},0)),"",LOOKUP(A1,{"ABC","DEFG","HIJ","KLM","NOP","QRST","UVW"}))