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?

 

[Fluff]

See post#3.

 

[rligh]

So the formula works beautifully, but isn't getting me the results I'd anticipated. Is there any way to tweak it to randomly choose a letter from the next sequential to Z?

Ie:

Sla - Sly
Meu - Slv

 

[Fluff]

Do you still want the vowel on the end if the last letter is a consonant?

 

[rligh]

No, that was making it too complicated.

 

[Fluff]

Ok, how about

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

 

[rligh]

Is there any chance to do it without the let function?

 

[rligh]

I'm using Numbers (Apple). Nearly every formula for excel works beautifully for that, but Let is not one of them.

 

[Fluff]

I'm using Numbers

In future when using something other than Excel, please make that clear, preferably in your title & you need to post such questions in the General Discussion & Other Applications section of the board. I have moved it for you this time.

 

[Fluff]

How about

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

 

[rligh]

Sorry, I meant to clarify. I am also using Numbers.