This is what I am needing to put into Column A
= B1 & " " & C1 & " " & D1 & " " & E1 & " " & F1 & " " & G1 & " " & H1 & " " & I1
wherein the numbers will correspond to the current row that it is pasted in. Is there a faster way than simply pasting it in and manually changing the 1’s to 2’s, or to 3’s or to 37892’s?
If I understand your question, there is nothing you have to do, given the formula as configured, except copy the cell and paste it in the target range (or drag the fill handle to paint the entire range). Here is why:
There are two types of cell adderss referencing: 1) absolute and 2) relative. Absolute cell address references precede column and/or row coordinates with a dollar sign ("$") to indicate to the spreadsheet app that the reference is locked in place. In other words, $A$1 won’t change as you copy or move it.
Relative cell addresses, on the other hand, do change as you copy or move them. A reference to cell A1 will change to A3 if moved or copied two cells down from its current location.
I hope this helps.
If you believe my response best answers your question, please click the checkmark next to my response.