如何在EXCEL中的字符串中找到第二个元音后的字符? [英] How to find the character after second vowel in a string in EXCEL?
问题描述
例如,如果我的字符串是
For example if my string is
Happy Song
The Happy Song
输出应该是
p。
p.
如果是空白,则显示Nothing
If it is a blank, then display "Nothing"
推荐答案
以下是我的答案。我还添加了检查是否有第二个元音的逻辑,如果没有它会抛出一个错误字符串。
Below is my answer. I've also added logic to check if there is a second vowel and if there isn't it throws an error string. See screenshot for details.
= IF(A1<>,IFERROR(MID(A1,FIND(|,SUBSTITUTE SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1), 一, |), E, |)中, i, |), O, |), U, |),FIND( |,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1), 一, |), E, |), i 的,|),o,|))+ 1)+1,1),no
second vowel found),)
=IF(A1<>"",IFERROR(MID(A1,FIND("|",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"a","|"),"e","|"),"i","|"),"o","|"),"u","|"),FIND("|",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"a","|"),"e","|"),"i","|"),"o","|"),"u","|"))+1)+1,1),"no second vowel found"),"")
< img src =https://i.stack.imgur.com/R0hqn.pngalt =在此输入图像说明>
这篇关于如何在EXCEL中的字符串中找到第二个元音后的字符?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!