Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I fill alphabetically ?
Hi,
Happy New Year 2010. May I know if I can fill A,B, C,.. ZZ across and downwards ? Thanks Low |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I fill alphabetically ?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I fill alphabetically ?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I fill alphabetically ?
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Can I fill alphabetically ?
Just to point out, if you change the 3 in Gary''s Student's formula to a 4,
it will work for up to 3 letters, so it is easily modified to handle XL2007/2010 worksheets as well. With that said, I would still use *your* formula as it involves one less function call, so it should be ever so slightly more efficient. -- Rick (MVP - Excel) "מיכאל (מיקי) אבידן" <micky-a*at*tapuz.co.il wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Can I speed fill from left to right ? | Excel Discussion (Misc queries) | |||
Fill Data in Excel 2002 and 2007 | Excel Worksheet Functions | |||
Fill Data in Excel 2002 and 2007 | Excel Worksheet Functions | |||
Excel 2002 : Can I speed fill tabs ? | Excel Discussion (Misc queries) | |||
cell fill colors in excel 2002 sp3 | Excel Worksheet Functions |