Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Assuming you'll start in cell A1 with "A", and make a column with this list, here's a formula you could copy all the way down: =LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,RO W(B1),4,1))-1) -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=399048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto fill color change | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |