Incrementing letters


O

Opinicus

How do you increment letters in Excel? That is, if I have a
"C" in A1 what formula will give me "D" in A2? I tried the
CHAR function but it doesn't do what I want.
 
Ad

Advertisements

B

Biff

Hi!

With "C" in A1:

Enter this in A2 and copy down as needed:

=CHAR(CODE(A1)+1)

Biff
 
Ad

Advertisements

R

RagDyer

You could create a "custom list", so that the alphabet will automatically
increment, just as the numbers do, and you'll never have to do it again.

Enter the alphabet in a column, and then select the column.

Then,
<Tools> <Options> <CustomLists>

The "Import List" window should have your selected cells already entered by
default.

Now, simply click on <Import>, then <OK>.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linear increments 2
incrementing numbers 1
incrementing numbers 2
Excel Incrementation 1
Incrementing the date 5
Increment a cell 1
Increment Formula 5
Formula will not increment 5

Top