Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

"Text" + calculation

Hi,

If i have a Week 1 in cell A1, can i have formula that says "Week" + 1

So the following week will be week 2, then week 3 etc

I have attached the ss

Thanks
PCM-Gambling-addicts.xlsx
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
James ElliottCommented:
Put this in cell A2

="Week " & (ROW()/2)

Open in new window


Then put "Result" in A3. Select both cells then fill down.

Rgds

Jell
0
 
Seamus2626Author Commented:
Thanks!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now