Altering CONCATENATE Formula cell value

[IGinc]

I have a spreadsheet where column J has a CONCATENATE formula, though it is not always constant, as in the near 700 rows, there are different items/etc. The problem is constant, when creating the spreadsheet, Column J and K are 1 row ahead. I have cleared up to 197, but now the spreadsheet is changing to often. So I have come here.

Here is I198

=CONCATENATE("<font face=verdana>",A198," ",B198,"<br><br>",E198," ",F198,"<br><br>",J199," ",K199,"<BR><BR>",L198," ",M198)

where it need needs to be

=CONCATENATE("<font face=verdana>",A198," ",B198,"<br><br>",E198," ",F198,"<br><br>",J198," ",K198,"<BR><BR>",L198," ",M198)

If needed the spreadsheet ends at row 685.

Can anyone help?

Thanks!

 

[Gerald Higgins]

Why not just edit it once, in one cell, and then copy that cell all the way down the column ?

 

[IGinc]

the formula is not all the same! Then I will unwanted html coding in column I. I would have to do it atleast 50-60 times. Change each formula and then fill/copy down

 

[Gerald Higgins]

OK, you've shown us what row 198 needs to be.

Can you give us an example of rows that are different from 198 ?
Show us what they need to be please.

I don't know what you mean by this . . .

Then I will unwanted html coding in column I

 

[IGinc]

ive decided to take this one on manually... it would take just as long to explain. Thanks for trying.