Google sheet function to identify abbreviated words

Note: this must work in google sheets. Don't offer to do in Excel.

We have a list of words that have the vowels missing. We need a function that will take each cell in a selected column and add a number to the next column. (if column A is selected, numbers should be added to column B, etc). The number should equal the number of contiguous consanants at the start of a word. The first letter should be ignored and included as 1 in the count. If no vowels after the first letter, value should be set to 0.

Reminder: vowels = A,E,I,O,U, sometimes Y


Prviding - 3 (three letters before i)

Advntis - 5 (five letters before i)

Andrwe - 5 (five letters before e)

Armstng - 0 (no vowels after the first letter)

Below is a link to a test sheet with words. Number to be added to column D. We are not sure if we want to include "Y" as a vowel. Make an easy way to change to add/remove Y as a vowel. To show us that you read this post and did not auto-bid-spam, put your favorite color as the **first word** in your bid.

File link:

Good luck

Skills: Google Sheets, Excel

See more: excel convert abbreviations, google sheets operators, google sheets functions, abbreviate names or words in excel, how to abbreviate words in excel, abbreviation for the word formula, excel abbreviation formula, excel abbreviation xls, google autocomplete function javascript, samples write 100 words note, vba calling sheet function, google maps function php, view next sheet function excel, google finance function, google finance function excel, php google index function, download google finance function, google autocomplete function, ebay abbreviated words, google analytics function php

About the Employer:
( 173 reviews ) Oconomowoc, United States

Project ID: #22802116

Awarded to:


black. that's my fav color!!! hi there! it's a very interesting project, as i keep all my records (including complex search/index/analytics/graphs) in my google sheets already. even, i'm using real-time currency conver More

$30 USD in 2 days
(1 Review)

7 freelancers are bidding on average $22 for this job


I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$30 USD in 1 day
(125 Reviews)

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many More

$30 USD in 1 day
(45 Reviews)

My friend... My prices are the lowest, my work is always original and I will give it before the deadline. I am producing quality content for my clients including; ARTICLE WRITING, ESSAY WRITING, RESEARCH PAPERS, THESI More

$10 USD in 1 day
(0 Reviews)

Please sir I give this to me I cAn complete in one day

$23 USD in 1 day
(0 Reviews)

Hi Sir, How are you? I hope you are well by the grace of almighty. You are looking for someone who can provide you a high-quality service with a very quick time. I am an expert in any kind of data entry job. I can pr More

$20 USD in 1 day
(0 Reviews)

Our company specializes in providing Data Entry/Data Processing work. We are Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make More

$10 USD in 2 days
(0 Reviews)