Like down a column?

I'd use this formula
=SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")
and copy down.

Then I'd convert it to values (edit|copy, edit|paste special|values)

Pawan arora wrote:

Hi I am not able to do alphabetic series in excel. etc A.......Z,AA,AB,AC

please help me out from this.

--

Dave Peterson