Setting up a word and advancing number in the same cell?

  • Thread starter Thread starter Lynn Bartling
  • Start date Start date
L

Lynn Bartling

Across a spreadsheet I have the date (i.e 07/04/03) and in the next cell I
have "Week 32"...I can set the cells up for the dates but I wondered if
there was a way to put the word "Week" in the cells and then have it
automatically add the next number... Week 33....Week 34. I wanted both the
word "Week" and the number "32" in the same cell. I would only want to do
it if it was fairly simple. Thanks.
Lynn
 
One way:

Assume "Week 32" is supposed to appear in column C (col #3)

Put in C1: ="Week "&COLUMN()+29
(The number "29" is used as 32=3+29. Adjust to suit to get the commencement
week #)

Copying across C1:F1 will give Week 32, Week 33, Week 34, Week 35
 
Thank you so much. This worked.
Lynn

Max said:
One way:

Assume "Week 32" is supposed to appear in column C (col #3)

Put in C1: ="Week "&COLUMN()+29
(The number "29" is used as 32=3+29. Adjust to suit to get the commencement
week #)

Copying across C1:F1 will give Week 32, Week 33, Week 34, Week 35
Click to expand...
 
Back
Top