| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a series of cells with multiple incrimenting characters
Try this:
="MM"&INT((ROWS($1:1)-1)/5)*2+1&CHAR(MOD(ROWS($1:1)-1,5)+65) copy down as far as needed "markb" wrote: Hi, I need to create a series of 1000 cells down a column. They will be in this format: MM1A MM1B MM1C MM1D MM1E MM3A MM3B MM3C MM3D MM3E MM5A MM5B MM5C ..... So, the first 2 characters are always the same, the 3rd character, an odd number incriments by 2 every 6th row, and the fourth character changes alphabetically through 5 rows, then it resets to "A"... Please give me some ideas? Thanks, -- Markb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
| CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS | Excel Discussion (Misc queries) | |||
| Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| Creating a High-Low-Close chart with multiple series? | Excel Discussion (Misc queries) | |||
Threaded Mode
