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]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what should happen if the last letter is a Z?

 

[rligh]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what should happen if the last letter is a Z?

It’s the version from the App Store. I wasn’t sure what to put for that. And, it’s not an issue since none of the words end in/before z. Thank you!

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B
1
2	Burwell	Burwelm
3	Checkley	Checklez
4	Rushden	Rushdeo
5	Yateley	Yatelez
6	Brympton	Brymptoo
7	Bradley Stoke	Bradley Stokf
8	Cosby	Cosbz
9	Shevington	Shevingtoo
10	Steyning	Steyninh
11	Croxley Green	Croxley Greeo
Main

Cell Formulas
Range	Formula
B2:B11	B2	=REPLACE(A2,LEN(A2),1,CHAR(CODE(RIGHT(A2))+1))

I'll be back with part 2 later

 

[rligh]

Ok, how about

+Fluff 1.xlsm
	A	B
1
2	Burwell	Burwelm
3	Checkley	Checklez
4	Rushden	Rushdeo
5	Yateley	Yatelez
6	Brympton	Brymptoo
7	Bradley Stoke	Bradley Stokf
8	Cosby	Cosbz
9	Shevington	Shevingtoo
10	Steyning	Steyninh
11	Croxley Green	Croxley Greeo
Main

Cell Formulas
Range	Formula
B2:B11	B2	=REPLACE(A2,LEN(A2),1,CHAR(CODE(RIGHT(A2))+1))

I'll be back with part 2 later

 

[rligh]

Ok, how about

+Fluff 1.xlsm
	A	B
1
2	Burwell	Burwelm
3	Checkley	Checklez
4	Rushden	Rushdeo
5	Yateley	Yatelez
6	Brympton	Brymptoo
7	Bradley Stoke	Bradley Stokf
8	Cosby	Cosbz
9	Shevington	Shevingtoo
10	Steyning	Steyninh
11	Croxley Green	Croxley Greeo
Main

Cell Formulas
Range	Formula
B2:B11	B2	=REPLACE(A2,LEN(A2),1,CHAR(CODE(RIGHT(A2))+1))

I'll be back with part 2 later

Thank you! I’m so confused by everything in range so I’m going to stick with the replace formula.

 

[Fluff]

Ok, if you do want the vowel as well, how about

+Fluff 1.xlsm
	A	B
1
2	Burwell	Burwelmo
3	Checkley	Checklezu
4	Rushden	Rushdeou
5	Yateley	Yatelezo
6	Brympton	Brymptoou
7	Bradley Stoke	Bradley Stokf
8	Cosby	Cosbzo
9	Shevington	Shevingtooi
10	Steyning	Steyninhe
11	Croxley Green	Croxley Greeoa
Main

Cell Formulas
Range	Formula
B2:B11	B2	=LET(r,CODE(RIGHT(A2)),REPLACE(A2,LEN(A2),1,CHAR(r+1)&IF(ISNA(MATCH(r,{97,101,105,111,117},0)),MID("aeiou",RANDBETWEEN(1,5),1),"")))

 

[rligh]

Thank you! I’ve searched this for a good two hours without success.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[jtakw]

Hi,

Just curious, what if you have a string that ends in "z" , like "chez" ??