The word Audrey
I use =left(b2,1) to find the out what the first letter of the word is =A
and =right(b2,1) to find out what the last letter of the word is =y
is there a formula to find out what the first vowel of the word is that is not the first letter
like in Audrey I need to know the first vowel after the first letter =U not A
try the above
=if(min(search({"a","e","i","o","u"},right(a1,len(a1)-1)&"aeiou"))+1>len(a1),"",mid(a1,min(search({"a","e","i","o","u"},right(a1,len(a1)-1)&"aeiou"))+1,1))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
MRozell 
Register To Reply
Bookmarks