Inserting Cell Data into Text

[kriseli]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]Special#[/TD]
[TD="align: center"]Section Title[/TD]
[TD="align: center"]Text[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]Title[/TD]
[TD="align: center"]The system shall support [ =A2 ] cycles.[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]Title[/TD]
[TD="align: center"]The system shall support [ =A3 ] cycles.[/TD]
[/TR]
</tbody>[/TABLE]
Hi All,

I want to reference the values in cells A2 and A3 in the "Text" column.

I would like it so that if I have to change the Special# value, I do not have to change the values in the corresponding "Text" column.

My plan is to do this for about 200 rows. Any help would be much appreciated!

 

[gaz_chops]

Try

="The system shall support "&A2&" cycles."