how to add text with numbers in which numbers should change accordingly

[kartikeya_raghupatro]

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:)

[#2]

@kartikeya_raghupatro 

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?

[#3]

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

[#4 · Accepted solution]

@kartikeya_raghupatro 

If you start from D5

with

="Lecture # "&(ROW()-ROW($D$5))*2+1&","&(ROW()-ROW($D$5))*2+2

[#5]

Thanks 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.:)

[#6]

@kartikeya_raghupatro 

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. :)

[#7]

@NowshadAhmed 
Thanks :)

[#8]

@kartikeya_raghupatro , you are welcome