如何以【客商：****】标识之间的字符串

huo200707

大家新年好：  本人想提取以   “【客商：****】”  标识的  之间的字符串

看见星光

1. =LEFT(MID(A2,FIND("【客商：",A2&"【客商：")+4,99),FIND("】",MID(A2,FIND("【客商：",A2&"【客商：")+4,99)&"】")-1)

复制代码

wswfzwswfz

=IF(COUNTIF(A2,"*客商*"),TRIM(LEFT(SUBSTITUTE(MID(A2,3+FIND("客商",A2),99),"】",REPT(" ",99)),50)),"")

龙城飞将III

乱入一下：

1. Function myGet(Rng As Range) As String
   
2.     On Error Resume Next
   
3.     With CreateObject("vbscript.regexp")
   
4.         .Pattern = "【客商：([\u4e00-\u9fa5]+)】"
   
5.         myGet = .Execute(Rng)(0).submatches(0)
   
6.     End With
   
7. End Function

复制代码

heike2004

=MID(A2,FIND("：",A2)+1,FIND("】",A2)-FIND("：",A2)-1)

huo200707

牛人，谢谢大家

excel我最爱

B2:

1. =IF(COUNT(FIND("客商",A2)),MID(SUBSTITUTE(A2,"】",REPT(" ",10)),FIND("客商",SUBSTITUTE(A2,"】",REPT(" ",10)))+3,10),"")

复制代码

公式下拉。

问山8828680

IFERROR(MID(A2,FIND("客商：",A2)+3,FIND("】",A2)-FIND("：",A2)-1),"")

问山8828680

MID(A2,FIND("客商：",A2&"客商：")+3,FIND("】",A2)-FIND("：",A2)-1)

首席打杂

1. =TRIM(LEFT(SUBSTITUTE(MID(A2,FIND("客商",A2&"客商")+3,99),"】",REPT(" ",99)),99))

复制代码