Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : Can I speed fill from left to right ? Mr. Low Excel Discussion (Misc queries) 2 February 22nd 08 11:03 PM
Fill Data in Excel 2002 and 2007 Display Name Excel Worksheet Functions 2 December 4th 07 12:09 PM
Fill Data in Excel 2002 and 2007 Display Name Excel Worksheet Functions 1 December 4th 07 06:49 AM
Excel 2002 : Can I speed fill tabs ? Mr. Low Excel Discussion (Misc queries) 4 September 11th 07 05:56 PM
cell fill colors in excel 2002 sp3 T Excel Worksheet Functions 0 August 30th 05 03:41 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"