How to number excel cells automatically

  • Thread starter Thread starter kkr
  • Start date Start date
K

kkr

I am using excel Sheet which contains around 1000 cells to be numbered
serially,
eg:A1 as X_XX_001_XX
A2 as X_XX_002_XXX
A3 as X_XX_003_XXXX ...
can anyone let me know solution for this...
 
In A1:

="X_XX_"&TEXT(ROW(),"000")&"_XX"

Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using excel Sheet which contains around 1000 cells to be numbered
| serially,
| eg:A1 as X_XX_001_XX
| A2 as X_XX_002_XXX
| A3 as X_XX_003_XXXX ...
| can anyone let me know solution for this...
 
="X_XX_"&TEXT(ROW(A1),"000")&"_XX"

works for any starting point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| In A1:
|
| ="X_XX_"&TEXT(ROW(),"000")&"_XX"
|
| Copy down as far as needed
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
||I am using excel Sheet which contains around 1000 cells to be numbered
|| serially,
|| eg:A1 as X_XX_001_XX
|| A2 as X_XX_002_XXX
|| A3 as X_XX_003_XXXX ...
|| can anyone let me know solution for this...
|
|
 
Back
Top