Removing vowels from words...
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
|