Forum Discussion
Solved
Numbering with prefix, without dragging
Hi, please, how thousands of rows in one column could be numbered, without dragging and with a letter prefix? Example: AHJS1000 AHJS1001 AHJS1002 ... thank you
- Let's say you want to start in row 2. Select the range, starting in that row, that you want to number, for example A2 to A100. Enter the formula ="AHJS"&(ROW()+998) Confirm with Ctrl+Enter.
Let's say you want to start in row 2.
Select the range, starting in that row, that you want to number, for example A2 to A100.
Enter the formula
="AHJS"&(ROW()+998)
Confirm with Ctrl+Enter.
Power Query was built to transform data. It will also push one towards the use of Tables which is probably the No1 improvement that can be made to any data analysis workbook.
How to do it so that the numbers remain the same even after moving to another row? To make them static values.
That is what you would get if you entered the first value in a cell, then dragged down. But you didn't want that...
Because I have thousands of lines, do you know of any alternative?
Thank you! 🙂
