如何提取最后一个带W的数据

越前

例如：370AB-3701W-371W-374D，提取371W，
370AB07-3701W-371W-3951W-396AF，提取3951W

nie414006

魚。。

1. =LOOKUP(9^9,-RIGHT(LEFT(A2,MAX(IF(MID(A2,ROW($2:$99),1)="W",ROW($1:$98)))),ROW($1:$9)))&"W"

复制代码

高个子

1. =TRIM(RIGHT(SUBSTITUTE(LEFT(A2,LOOKUP(1,0/(MID(A2,ROW($1:$99),1)="W"),ROW($1:$99))),"-",REPT(" ",99)),99))

复制代码

佛山小老鼠

1. =VLOOKUP("-*W",RIGHT(LEFT(A2,COUNT(FIND("W",A2,ROW($1:$99)))),ROW($1:$9)+{1,0}),2,0)

复制代码

剑指E

=TRIM(LEFT(SUBSTITUTE(MID(A2,AGGREGATE(14,6,SEARCH("-*W",A2,ROW($1:$99)),1)+1,9),"-",REPT(" ",99)),99))

静听溪流

=FILTERXML("<a><b>"&SUBSTITUTE(A2,"-","</b><b>")&"</b></a>","//b[contains(.,'W')][last()]")

静听溪流

=TEXTAFTER(TEXTBEFORE(A2,"W",-1),"-",-1)&"W"

quqiyuan

1. =TAKE(FILTER(TEXTSPLIT(A2,"-"),ISNUMBER(FIND("W",TEXTSPLIT(A2,"-")))),,-1)

复制代码

niko88819

B2 公式

1. =ExtractLastW(A2)

复制代码

1. Function ExtractLastW(str As String) As String
   
2.     Dim arr() As String
   
3.     Dim i As Integer
   
4.    
   
5.     arr = Split(str, "-")
   
6.     For i = UBound(arr) To 0 Step -1
   
7.         If Right(arr(i), 1) = "W" Then
   
8.             ExtractLastW = arr(i)
   
9.             Exit Function
   
10.         End If
    
11.     Next i
    
12.    
    
13.     ExtractLastW = ""
    
14. End Function
    

复制代码