Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Incrementing letters

3 views
Skip to first unread message

Opinicus

unread,
Nov 3, 2005, 1:23:00 AM11/3/05
to
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.

--
Bob

Kanyak's Doghouse
http://www.kanyak.com

Biff

unread,
Nov 3, 2005, 1:32:42 AM11/3/05
to
Hi!

With "C" in A1:

Enter this in A2 and copy down as needed:

=CHAR(CODE(A1)+1)

Biff

"Opinicus" <gez...@spamcop.net> wrote in message
news:11mjb33...@news.supernews.com...

Opinicus

unread,
Nov 3, 2005, 5:27:56 AM11/3/05
to
"Biff" <biffi...@comcast.net> wrote in message
news:uUvulBE...@TK2MSFTNGP15.phx.gbl...

> With "C" in A1:
> Enter this in A2 and copy down as needed:
> =CHAR(CODE(A1)+1)

CODE! (Slaps self on forehead.) Thanks!

RagDyer

unread,
Nov 3, 2005, 9:05:09 PM11/3/05
to
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!
==============================================

"Opinicus" <gez...@spamcop.net> wrote in message

news:11mjphe...@news.supernews.com...

0 new messages