单元格内含多个同一个字符提指定序号字符前的所有文本

hxj119

=TRIM(LEFT(SUBSTITUTE(B3,"-",REPT(" ",99),LEN(B3)-LEN(SUBSTITUTE(B3,"-",))-1),99))

jivy1212

1. =LEFT(B3,LEN(B3)-MATCH("-*-*",RIGHT(B3,ROW($1:$66)),))

复制代码

hxj119

office365或最新WPS，参考公式二：
=TEXTJOIN("-",,DROP(TEXTSPLIT(B3,"-"),,-2))

回吧天堂

手动输入想要结果的第一个和第二个，选中整个结果区域，Ctrl+E

回吧天堂

=LEFT(B3,FIND("+",SUBSTITUTE(B3,"-","+",LEN(B3)-LEN(SUBSTITUTE(B3,"-",""))-1))-1)

swl4561255

自定义函数：

1. Function TiQu(mys As String)
   
2. Dim brr()
   
3. arr = Split(mys, "-")
   
4. For i = 0 To UBound(arr) - 1
   
5.   ReDim Preserve brr(0 To i)
   
6.   brr(i) = arr(i)
   
7. Next
   
8. TiQu = Join(brr, "-")
   
9. End Function
   

复制代码