| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment numbers part of text
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment numbers part of text
="Q"&IF(MID(A1,2,1)="4",1,MID(A1,2,1)+1)&IF(MID(A1 ,2,1)="4",RIGHT(A1,4)+1,RIGHT(A1,4))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Saintsman" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment numbers part of text
Many thanks!
"Bob Phillips" wrote: ="Q"&IF(MID(A1,2,1)="4",1,MID(A1,2,1)+1)&IF(MID(A1 ,2,1)="4",RIGHT(A1,4)+1,RIGHT(A1,4)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Saintsman" wrote in message ... 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? |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
