这个比较简单:

=REGEXEXTRACT(A1,"[^/]+$")

您可以使用以下公式:

=REGEXEXTRACT(A1,"(?:.*/)(.*)$")

也可以将其用作ArrayFormula:

And also possible to use it as ArrayFormula:

=ARRAYFORMULA(REGEXEXTRACT(A1:A3,"(?:.*/)(.*)$"))

这里有更多信息:

• RegExExtract函数
• 语法的一些很好的例子
• 我的个人正则表达式技巧列表

• the RegExExtract function
• Some good examples of syntax
• my personal list of Regex Tricks

此公式将执行以下操作:

This formula will do the same:

=INDEX(SPLIT(A1,"/"),LEN(A1)-len(SUBSTITUTE(A1,"/","")))

但是A1需要三遍，这是不可能的.

But it takes A1 three times, which is not prefferable.