Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Need formula for next letter in alphabet in google spreadsheet

I've searched for a while but I can't find the function to get the next letter in the alphabet. Does it exist?

A1="A"
=char(A1+1);
expected result  "B"
like image 868
Richard de Ree Avatar asked Aug 30 '25 18:08

Richard de Ree


1 Answers

Use this instead:

=CHAR(CODE(A1)+1)

enter image description here

This will work for capital letters A through Y.

like image 54
Gary's Student Avatar answered Sep 03 '25 00:09

Gary's Student