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.