Carrying on a Sequence?

Hi all,

Trying to find a quick way to replicate a sequence right down a column.

Basically my column goes like this:

A1
bccd01_01
bccd02_01
bccd03_01
bccd04_01

...and so on.

Is there a quick way i can run this right down the column from bccd01_01 through to bccd99_01 ?

Thanks in advance
C

Originally Posted by NBVC

In A2, enter formula:

Please Login or Register  to view this content.

and copy down.

wow!!?!? thanks - works a treat!