求助！如何在单元格中提取 直营 代理 总部 这三个字段

你要提取什么，请举例说明

你可以数据复制到文档，然后粘贴到贴吧

这个太简单，就是查找而已，而且数据没有多项。

写一个公式，A2输入
=LOOKUP(1,0/FIND({"直营","代理","总部"},B2),{"直营","代理","总部"})

我只用vba
Function f(a As String) As String
Dim i As Integer, j As Integer, k As Byte
Dim gg As Variant
gg = Array("直营", "代理", "总部")
k = 0
For i = 1 To Len(a) - 1
For j = 0 To 2
If Mid(a, i, 2) = gg(j) Then
f = gg(j)
k = 1
Exit For
End If
Next j
If k = 1 Then Exit For
Next i
End Function

VBA····instr，find，like都能做，实在不济mid也能做
函数只会lookup