Forum Discussion
Solved
how to add text with numbers in which numbers should change accordingly
Hello, I wanted to know how to write text with numbers in which numbers should increase continuously but the text should remain constant. I want the lectures to be continued as Lecture #1,2 then Lecture #3,4 Lecture #5,6 and so on. I would be very happy to get a reply:)
If you start from D5
with
="Lecture # "&(ROW()-ROW($D$5))*2+1&","&(ROW()-ROW($D$5))*2+2
7 Replies
Hi, you have selected your own reply seeking help/corrections as the best response. Please, select the reply from Sergei Baklan that helped you with what you are looking for.
It will help others who are facing similar problem, find answers quickly. 🙂
NowshadAhmed
Thanks 🙂
If you drag down by right click first value
result will be
Or you need a formula ? When on which Excel version/platform you are?
- Sir, I am in Excel 2019.
I want the lectures to be continued as
Lecture #1,2
Lecture #3,4
Lecture #5,6 and so on.
Thank u for ur replyIf you start from D5
with
="Lecture # "&(ROW()-ROW($D$5))*2+1&","&(ROW()-ROW($D$5))*2+2
