ExcelBanter - How to number excel cells automatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to number excel cells automatically (https://www.excelbanter.com/excel-worksheet-functions/193146-how-number-excel-cells-automatically.html)

kkr

How to number excel cells automatically

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...

Niek Otten

How to number excel cells automatically

In A1:

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

Copy down as far as needed

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"kkr" wrote in message ...
|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...

Niek Otten

How to number excel cells automatically

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

works for any starting point

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| In A1:
|
| ="X_XX_"&TEXT(ROW(),"000")&"_XX"
|
| Copy down as far as needed
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "kkr" wrote in message ...
||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...
|
|

All times are GMT +1. The time now is 11:50 PM.