Question

EXCEL中如何用函数公式，在字符串查到包含的一个字母

列A：B2-101
E3-222
F4-333...
查找第一个字母是A或B或C或D，则B列返回文本 海鲜。若第一个字母是E或F或G或H，则B列返回文本 冻品

有高人在吗？！求助啊求助！！

Answer 1

=IF(OR(LEFT(A1)={"A","B","C","D"}),"海鲜",IF(OR(LEFT(A1)={"E","F","G","H"}),"冻品","") )

Answer 2

B1格输入
=IF(OR(LEFT(A1)="A",LEFT(A1)="B",LEFT(A1)="C",LEFT(A1)="D"),"海鲜",IF(OR(LEFT(A1)="E",LEFT(A1)="F",LEFT(A1)="G",LEFT(A1)="H"),"冻品","") )
向下填充拖动

Answer 3

=IF(OR(LEFT(A1)={"A","B","C","D"}),"海鲜","冻品")