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 Lect...
If you start from D5
with
="Lecture # "&(ROW()-ROW($D$5))*2+1&","&(ROW()-ROW($D$5))*2+2
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 reply
I want the lectures to be continued as
Lecture #1,2
Lecture #3,4
Lecture #5,6 and so on.
Thank u for ur reply
If you start from D5
with
="Lecture # "&(ROW()-ROW($D$5))*2+1&","&(ROW()-ROW($D$5))*2+2Thanks a million, sir. U made my day. this is the first time I came to the Microsoft community and this was the feedback, absolutely amazing.🙂
kartikeya_raghupatro , you are welcome