Thread: Increment numbers part of text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saintsman Saintsman is offline
external usenet poster
  
Posts: 81
Default 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?
Reply With QuoteReply With Quote