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"
Use this instead:
=CHAR(CODE(A1)+1)
This will work for capital letters A through Y.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With