Thread: Excel 2002: Can I fill alphabetically ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low[_3_] Mr. Low[_3_] is offline
external usenet poster
  
Posts: 19
Default Excel 2002: Can I fill alphabetically ?
Thanks.

"Gary''s Student" wrote:

In A1:

=SUBSTITUTE((LEFT(ADDRESS(1,COLUMN()),3)),"$","") and copy across
--
Gary''s Student - gsnu200909


"Mr. Low" wrote:

Hi,

Happy New Year 2010.

May I know if I can fill A,B, C,.. ZZ across and downwards ?


Thanks

Low
Reply With QuoteReply With Quote