increasing letters not numbers

[hond]

Hi,

I dont know to decribe the problem, so I will do it with this example:

I dont want this

A1=value in cell (copy down)
A2
A3
A4
A5

I want this when copying down
A1
B1
C1
D1
E1

How do I do this?

Please help!

Thanks

[martindwilson]

if you just want that from a through z in a column copied down
=CHAR(65+ROWS($A$1:A1)-1)&1

[Jakobshavn]

If you want the transpose of the items in the first row into the first column, then in A2 enter:

=OFFSET(A$1,0,ROW()-1) and copy down

[bebo021999]

Another option:
=ADDRESS(1,ROW(A1),4)

[martindwilson]

well if its transpose then
=INDEX($1:$1,ROWS(A$1:A1))

[hond]

Hi,

Thank you for your responces, but I am not sure how to implement this (I am an exel noob)

I have a cell (M3)with this formula in it

=VLOOKUP(M2,A1:K9999,11,) The formula returns A160

Now i want M4:M10 to be B160,C160,D160 and so on.

If A160 changes, I want these cells to changes with it.

Thanks!

[martindwilson]

try
=CHAR(CODE(LEFT($M$1))+ROWS($A$1:A1))&RIGHT(A1,LEN(A1)-1)

[bebo021999]

Try this in M4:

Please Login or Register  to view this content.

Finished with Ctrl-Shift-Enter

[hond]

reply to martin:

I copied the formula in M4, got VALUE!. Changed $M$1 to $M$4 (wich has A160 in it) got "Bate"

[hond]

reply to bebo:

got this error: The specified formula cannot be entered because it usees more levels of nesting than are allowed in the current file format.

[martindwilson]

oops
=CHAR(CODE(LEFT($M$3))+ROWS($A$1:A1))&RIGHT($M$3,LEN($M$3)-1)

[hond]

Can't thank you enough!

[bebo021999]

oops
=CHAR(CODE(LEFT($M$3))+ROWS($A$1:A1))&RIGHT($M$3,LEN($M$3)-1)

What if M3=Z160? or AA160? Solution in #8 may solve problem.