| 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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
