Forum Discussion

temporalnaut's avatar
temporalnaut
Copper Contributor
Jul 25, 2020
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
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jul 25, 2020
    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.
HansVogelaar's avatar
HansVogelaar
MVP
Jul 25, 2020
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.

Resources