Add 1 to a cell containing text and number and retain text

[Rasmusjc]

Hi

I have been searching for, what i think is quite easy, but unfortunatly i cant figure out how to solve my problem.

In cell A1 i have = "Week " 1 ~ Displaying Week 1
In cell i A2 i need = A1 + 1 ~ Displaying Week 2
continue in A3 ect.

I just cant figure out how to make a formular that multiply A1 with 1

Hope you can help me
Best regards.

 

[sandy666]

maybe
A1: ="Week "&ROW() and drag down

 

[jolivanes]

If, you can't use the row number (you could make it relative of course).
If "Week 1" is in Cell F5, in Cell F6

=LEFT(F5, 5) & MID(F5, 6,99) + 1

Drag down as far as needed

 

[Rasmusjc]

Thank to both of you for taking your time.

Went with Jolivanes solution.