hello to all,
I hope you and your family are doing well.
I'm looking for a vba solution or a formula that would allow me to do the following:
for a given word in A1
- if the 2nd letter of this word is a vowel, then replace the 1st letter of the word by all the consonants,
otherwise replace the 1st letter of the word by all the vowels
e.g:
PARIS would give BARIS; CARIS; DARIS…ZARIS
ARBRE would give EBRE;IBRE;OBRE;UBRE,YBRE
no matter if the word exist or not
can someone help?
I hope you and your family are doing well.
I'm looking for a vba solution or a formula that would allow me to do the following:
for a given word in A1
- if the 2nd letter of this word is a vowel, then replace the 1st letter of the word by all the consonants,
otherwise replace the 1st letter of the word by all the vowels
e.g:
PARIS would give BARIS; CARIS; DARIS…ZARIS
ARBRE would give EBRE;IBRE;OBRE;UBRE,YBRE
no matter if the word exist or not
can someone help?
Last edited: