Excel 2002: Can I fill alphabetically ?
Glad to help.
Please note that although you mentioned ZZ - Gary''s Student formula will
present up to 2(!) Letters only.
Those who need to present and/or use ALL 2^14 Columns letters in Excel
"2007/2010" should consider to use my suggestion.
Micky
"Mr. Low" wrote:
Thamks
Low
"מיכאל (מיקי) אבידן" wrote:
Same approach but "a little shorter":
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
Micky
"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
|