Replace last character with its sequential letter for Numbers (Apple)

[rligh]

How can I go about this?

I have a list of words in col A. I want to replace the last letter of each word with the next letter of the alphabet. Bonus points if I can stick a random vowel next to it if it’s a consonant.

Ie:
Doh - Dogu
Vef - Vegi
Sah - Sai

Is this doable?

 

[rligh]

How about

=REPLACE(A2,LEN(A2),1,CHAR(RANDBETWEEN(CODE(RIGHT(A2))+1,122)))

You are a genius. Thank you so much.

 

[Fluff]

I am also using Numbers.

Ok, that's fine, but I would advise you mention that if it needs to work in both.

Thank you so much.

Glad to help & thanks for the feedback.