how to do numbering of rows in excel sheet

G

Guest

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

Guest

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

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

Match and delete rows on two different sheets from reference numbers 4
COUNT rows on external sheet if between date range 3
Autofill alphanumeric prefix in Excel 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Excel Help: tracing formulas between cells within workbopok 1
Synchronize data across 2 sheets 2
using the =page! feature to transpose a row to column 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1

Top