| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a series of cells with multiple incrimenting characters
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
