VBA consonant extract

  • Thread starter Thread starter Bubu
  • Start date Start date
B

Bubu

I would like to calculate the following Code, in VBA ( excel 97).

Whith the following information :

Last Name
First Name
Middle Name
they may be in range a1,a2,a3

I have to get a result of 6 characters.
---********************************************************************---

3 chars (Letters) for Last Name
the first three consonant, or ..
" vowel "
or
" x "

Example for Last Name ( or for First Name)
rs=rsx
ra=rax
ar=rax
aa=aax
ae=aex
aei=aei
aeih=hae

---********************************************************************---

3 chars (Letters) for First Name + Middle Name ( like they were a whole name )
the first three consonant, or ..
" vowel "
or
" X "


'*****************************'
Example for Last Name
Same as for Last Name
'*****************************'

Example for First + Middle Name

I consider
first middle, like it was firstmiddle
first middle = frs
aa rsh=rsh
ae waeiourt=wrt
aeiou aeist=sta
aeih =hae
aa = aax

---********************************************************************---

Shoul i write a functio like isconsonant and is vowel or what ?

Any Help ?

Thanks.

Best Regards.

Robert.
 
It is a very good start, i will play a little to my need.

Thank You Very Much.

Best Regards,

Robert.
 
Back
Top