Fill series (I think) query

[grim72]

I want to run a series of cells but can't figure out how to do it.
eg
Cell A1 to contain the data 2A
the next cell (A2) to read 2B
the next 2C etc etc

I've tried just dragging the cells down but it just duplicates 2A, 2B, 2C whereas I want it to fill the next cells as 2D, 2E etc
and I've tried using the fill series option but neither seems to be working (presumably due to the letter) - anyone know a quick and easy solution? Seems like it is an obvious one but can't remember how.

[bebo021999]

Try in A1:
=2&MID(ADDRESS(1,ROW()),2,1)
drag down

[grim72]

Thanks - that works. I also need it follow a pattern going across the row too, so it looks like below:
2A 3A 4A 5A
2B 3B 4B 4C
2C 3C 4C 5C
Is there an easy way to do this - without having to keep typing in things?

[bebo021999]

Seem it do:
=COLUMNS($A:B)&MID(ADDRESS(1,ROW()),2,1)

[grim72]

Perfect thanks