So I have several lines of data and I am creating a concatenation statement. I enter the statement in row 1 and copy it down. The formula that shows in the formula bar correctly updates the row numbers as you go down but the data in the formula continues to be that of row 1. However, if, for any given row, I click into the formula bar and hit enter the data updates to that of the row. i.e. row 5 then would be correct. This would be fine to do except that there are 5000+ lines.

Any thoughts?