Removing vowels from words...
There was no i in the example <g
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Dave Peterson" wrote in message
...
Just to add to Bob's formula.
=substitute() is case sensitive (and I bet autocorrect changed his i to I
<bg).
Another alternative:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(LOWER(A1),
"a",""),"e",""),"i",""),"o",""),"u","")
Bob Phillips wrote:
no VBA
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(A1,"a",""),"e",""),"I",""),"o",""),"u","")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
wrote in message
...
How to remove vowels from words? Fpr example, in one row we have
google, excell, macro,... and the result in another row is ggl, xcll,
mcr,... Thanks.
--
Dave Peterson
|