![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 50%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | Other | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Yes, the formula you provided can automatically adjust the row number when pasted into a different row in Excel. This behavior is due to Excel's relative referencing feature. When you use a formula like =CONCAT("CP-",K7,".",N7,L7) and paste it into another row, Excel will automatically change the row references to match the new row number.
For example, if you paste the formula into row 56, it will change to =CONCAT("CP-",K56,".",N56,L56). This allows you to maintain the same formula structure while applying it across different rows without needing to manually adjust the row numbers.
If you want to ensure that certain references remain constant (for example, if you want to always refer to K7), you can use absolute references by adding dollar signs, like this: =CONCAT("CP-",$K$7,".",N7,L7). In this case, K7 will not change when you paste the formula into another row.
Overall, your formula will work as intended when pasted into different rows, adjusting the row numbers automatically.