LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default creating a list of letters in a column

I need to create a column that letters the row. For example, A1 is A, A2 is
B. There are about 150 rows, so it needs to loop through AB, AC etc.

I would like to find a formula to do this so that if I add a row, it
recalculates the entire column.

Thanks,

--
Lila


 
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
Creating emailing list from column of addresses Howard Excel Discussion (Misc queries) 2 April 9th 10 06:38 PM
creating a pick list from more than one column subroc Excel Discussion (Misc queries) 2 June 27th 09 01:21 PM
Creating a dropdown list within a column dsebiz Excel Discussion (Misc queries) 4 March 19th 08 05:56 PM
How do change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM
creating a list from a column of semicolon instauratio Excel Discussion (Misc queries) 3 June 21st 05 11:11 PM


All times are GMT +1. The time now is 06:25 AM.

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

About Us

"It's about Microsoft Excel"