Excel里我有个文本的内容是A/B//C///D///E/F/G,我想把从右边数起第一个的"//"的右边的内容提取出来,提取结果应该是E/F/G,公式怎么可以做到?注意是双斜杠,但文本里是有三斜杠的。
ä¸è½çvbaå¯ä»¥å®ç°ãå½æ°å ¬å¼è¿æ¯æé¾åº¦çã
èªå®ä¹å½æ°ä»£ç ï¼
Function SXG(S As String) As String
Const XG = "/"
Dim XGGS As Integer
For I = Len(S) To 1 Step -1
If Mid(S, I, 1) = XG Then
XGGS = XGGS + 1
Else
If XGGS = 2 Then
SXG = Mid(S, I + 3)
Exit Function
Else
XGGS = 0
End If
End If
Next I
SXG = ""
End Function
è¿è¡ç»æå¦å¾