How to number excel cells automatically

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

Niek Otten

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

Niek Otten

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
copy specific cells from sheets if the information is correct 3
Mail Merge Directory Conditional Page Break 0
Converting a number into a cell reference 2
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Function help required... Between funtion 5
Referencing cells in consecutive rows 2

Top