英文:
Excel: Get text between two characters
问题
以下是您要翻译的代码部分：
= MID（A5，SEARCH（"/"，A5）+1，SEARCH（"'"，A5） - SEARCH（"/"，A5） -1）
和
= MID（RIGHT（A5，FIND（"/"，A5）-1），FIND（"/"，A5）+1，LEN（A5））
但不幸的是它们没有起作用。
英文:
I'm trying to get the text between the last / and ' in the column below:
So that my answer will be:
I tried using the formulas:
=MID(A5, SEARCH("/", A5)+1, SEARCH("''", A5) - SEARCH("/", A5) -1)
and
=MID(RIGHT(A5,FIND("/",A5)-1),FIND("/",A5)+1,LEN(A5))
But unfortunately they aren't working.
答案1
得分: 4
你可以尝试这个：
=SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","")
输出如下：
类似地，获取文本之前的方法：
=SUBSTITUTE(TEXTBEFORE(A1:A4,"/",-1),"'","")
英文:
You can try this:
=SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","")
Here is the output:
Similarly to get the text before:
=SUBSTITUTE(TEXTBEFORE(A1:A4,"/",-1),"'","")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论