CODEWITHSUNDEEP
excelexcel-formula
mismas
mismas

Reputation: 1316

Excel formula for increasing number

How can I write Excel formula for this: 

TC-SM-001
TC-SM-002
TC-SM-003
... etc.

I would like to start it from an arbitrary position in the sheet and then to have the incrementation. Also, I would like the numbers to increment automatically if I delete or add the row somewhere in the middle.

Upvotes: 1

Views: 159

Answers (1)

user4039065
user4039065

Reputation:

Use one of these in a cell somewhere on the worksheet.

="TC-SM-"&text(row(1:1), "000")
=text(row(1:1), "TC-\S\M-000")

Fill down as necessary. Replace ROW(1:1) with any other starting or seeding number you prefer to start at; e.g. ROW(95:95) to start at TC-SM-095.

        TEXT concatenation and sequential numbers

If the above formulas are giving you an error, your computer system's regional settings may have a semi-colon as the list delimiter. 

="TC-SM-"&text(row(1:1); "000")
=text(row(1:1); "TC-\S\M-000")

Upvotes: 4

Related Questions