ExcelBanter - how to do numbering of rows in excel sheet

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

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

- - how to do numbering of rows in excel sheet (https://www.excelbanter.com/excel-worksheet-functions/139095-how-do-numbering-rows-excel-sheet.html)

anshu

how to do numbering of rows in excel sheet

hi
I wnt to do numbering in excel sheet . There should be a prefix like:
ANA etc. for each row.

Max

how to do numbering of rows in excel sheet

One ways

Put in any starting cell as desired, say in C3:
="ANA"&TEXT(ROW(A1),"000")

Copy C3 down as far as required to return the series:

ANA001
ANA002
ANA003
etc

Modify to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anshu" wrote:
hi
I wnt to do numbering in excel sheet . There should be a prefix like:
ANA etc. for each row.

All times are GMT +1. The time now is 01:23 AM.