Hello!

I have a relatively basic question.

I want to set values to a range of cells in Excel, using the formula = $A$1 & "." & 1. (or ="Question."&1, not to complicate my question too much)

In my case A1 is the title of the section, say 'Question', but that varies from section to section.

A1  Question

A2  Question.1 (formula =$A$1&"."&1)

A3  Question.2 - this is how I want it to be, and the next cells should be Question.3, Question.4 etc.

Now Question.2 is what I want to be written in A3 but dragging the formula from A2 doesn't work. And I really want this to work automatically (drag the formula), because I'm operating with cca. 1000 cells.

Does anybody have a solution?

Many thanks, Peter