| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a list of letters in a column
Wonderful! Thanks!
Lila "Tom Ogilvy" wrote in message ... This is a bit simpler: =MID(ADDRESS(1,ROW(),4,TRUE,""),2,1+(ROW()26)) if you don't start in A1, change Row() to something like Row()-4. This would be if the formula starts in A5 as an example. -- Regards, Tom Ogilvy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating emailing list from column of addresses | Excel Discussion (Misc queries) | |||
| creating a pick list from more than one column | Excel Discussion (Misc queries) | |||
| Creating a dropdown list within a column | Excel Discussion (Misc queries) | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| creating a list from a column of semicolon | Excel Discussion (Misc queries) | |||
Hybrid Mode
