crack this!!

I need a clever Trevor to help me crack the following regular expression find-replace issue (I think...):

I have the following 3 columns in an excel sheet.

Using the 1st row as an example, Column 1 reads
arrItems1[0] = "
Column 2 reads
Aberdeen ";
Column 3 reads
arrItemsGrp1[0] = 1;

As below:

arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Addo "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Adelaide "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Alexandria "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Alice "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Aliwal North "; arrItemsGrp1[0] = 1;
arrItems1[0] = " Balfour "; arrItemsGrp1[0] = 1;

I need to replace in column 1 and colum 3, the number in the [] 's to increment by one in the next row:

arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1;
arrItems1[1] = " Addo "; arrItemsGrp1[1] = 1;
arrItems1[2] = " Adelaide "; arrItemsGrp1[2] = 1;
arrItems1[3] = " Alexandria "; arrItemsGrp1[3] = 1;
arrItems1[4] = " Alice "; arrItemsGrp1[4] = 1;
arrItems1[5] = " Aliwal North "; arrItemsGrp1[5] = 1;
arrItems1[6] = " Balfour "; arrItemsGrp1[6] = 1;

Your knowledge will be much appreciated!!

Thanking you in anticipation!

wouldn't it just be something like

="arrItemsGrp1["&text(row(A1)-1,"0")&"]"

copied down?



"theonlymac" wrote:

>
> I need a clever Trevor to help me crack the following regular expression
> find-replace issue (I think...):
>
> I have the following 3 columns in an excel sheet.
>
> Using the 1st row as an example, Column 1 reads
> -arrItems1[0] = "-
> Column 2 reads
> -Aberdeen ";-
> Column 3 reads
> -arrItemsGrp1[0] = 1;-
>
> As below:
>
> arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Addo "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Adelaide "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Alexandria "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Alice "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Aliwal North "; arrItemsGrp1[0] = 1;
> arrItems1[0] = " Balfour "; arrItemsGrp1[0] = 1;
>
> I need to replace in column 1 and colum 3, the number in the [] 's to
> increment by one in the next row:
>
> arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1;
> arrItems1[1] = " Addo "; arrItemsGrp1[1] = 1;
> arrItems1[2] = " Adelaide "; arrItemsGrp1[2] = 1;
> arrItems1[3] = " Alexandria "; arrItemsGrp1[3] = 1;
> arrItems1[4] = " Alice "; arrItemsGrp1[4] = 1;
> arrItems1[5] = " Aliwal North "; arrItemsGrp1[5] = 1;
> arrItems1[6] = " Balfour "; arrItemsGrp1[6] = 1;
>
> Your knowledge will be much appreciated!!
>
> Thanking you in anticipation!
>
>
> --
> theonlymac
> ------------------------------------------------------------------------
> theonlymac's Profile: http://www.excelforum.com/member.php...o&userid=32444
> View this thread: http://www.excelforum.com/showthread...hreadid=522247
>
>

Thanks! Appreciated!