in excel create series in the presence of [ ] characters
 

I need to create a series like this:

text[1]
text[2]
text[3]
..
..
text[n]

Excel will not let me do this in the presence of the [].

Is there a way around this?

Thanks

If you want to start in row 3 try
="text["&(row()-2)&"]"
and copy down.
then I would probably copy this column and paste special values.

"Tom" wrote:

I need to create a series like this:

text[1]
text[2]
text[3]
.
.
text[n]

Excel will not let me do this in the presence of the [].

Is there a way around this?

Thanks