in excel create series in the presence of [ ] characters

T

Tom

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
 
B

bj

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.
 
Top