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
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 🙂
