Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Is there a way to quickly change the row number when doing = B1, = B2, ect. for thousands of rows?

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?