i Have the following data on B and C
DNL DANELAW
DNL ADNEXAL
I want formula on a1 drag down to give me result as follows
W
X
i Have the following data on B and C
DNL DANELAW
DNL ADNEXAL
I want formula on a1 drag down to give me result as follows
W
X
I should work any vowel combination like this too
DNL BALADIN
DNL PALADIN
Result will be
B
P
Need more examples please in W/book. And in future a better explanation of what is required !
Last edited by JohnTopley; 07-15-2021 at 02:28 PM.
This
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C1,MID(B1,1,1),""),MID($B1,2,1),""),MID($B1,3,1),""),"A",""),"E",""),"I",""),"O",""),"U","")
Thank you I am sorted so quick , Thank you so much again
Here is a more compact array-entered** formula for you to consider that will also work...
=MID(C1,MAX(IF(ISERROR((FIND(MID(C1,ROW($1:$99),1),B1&"AEIOU"))),ROW($1:$99),0)),1)
**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks