like对比可以加or吗，自己试了下不行，想执行这样的语句

﹎嘘、安静

If [a1] Like "外六角" Or [a1] Like "六角" Or [a1] Like "六角头" Then


写成这样的语句我知道，但是每增加一个的对比都要输入一次  [A1]


要怎么写才可以都针对同一个字符来对比呢

清风竹-

If [a1] Like "*" & "六角" & "*" Then
     [a2] = "外六角"
  End If

  If [a1] Like "*" & "六角" & "*" And [a1] Like "*" & "全牙" & "*" Then
    [a3] = "全牙外六角"
   Else
    [a3] = ""
   
  End If

  If [a1] Like "*" & "六角" & "*" And [a1] Like "*" & "半牙" & "*" Then
    [a4] = "半牙外六角"
  Else
    [a4] = ""
  End If

做个参考，不一定准确。