| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment numbers part of text
I'd insert a new worksheet (temporarily)
Put this in A1 and drag down: ="Q"&MOD(ROW()-1,4)+1&2008+INT((ROW()-1)/4) Select what you want edit|copy go to where you want it edit|Paste special|Values You could even fiddle around with the formula and use it in place... If I wanted Q12008 to be in X79, I'd use: ="Q"&MOD(ROW()-3,4)+1&1989+INT((ROW()-1)/4) Saintsman wrote: How can I add automate quarter year headings? Q12008 then add 1 to quarter until Q4 & then add 1 to year & restart at Q1 etc to give: Q22008 Q32008 Q42008 Q12009 Can anybody help? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Increment Row Numbers | New Users to Excel | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| Increment and subtract Numbers | Excel Worksheet Functions | |||
| Increment numbers in a column | Excel Discussion (Misc queries) | |||
| increment invoice numbers in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
