Column row

[smokenack]

Hi, I just want to write a formula so that cell A1 will show as text AA, cell B1 will show AB etc.

I thought something like = "A" + COLUMN() but obviously this doesnt work or I wouldnt be asking.

I haven't used excel for a while now, thanks for your help

Nick

 

[Phanmore]

="A"&CHAR(COLUMN()+64)

Will only work up until AZ

 

[smokenack]

Thanks for your help, but the formula is returnibg FALSE as a result.

Nick

 

[Phanmore]

Try

="A"&MID(CELL("Address",A1),LEN(CELL("Address",A1))-2,1)

Not sure why your getting false for the first formula.

 

[smokenack]

Thanks, thats working up to row 9, its returning A$ in cell A10.

Nick

 

[smokenack]

Sorry to mess you about, your first formula is working fine now. ????

many thanks

Nick