adding increasing numbers in column to existing text

I am trying to add increasing numbers to existing column of text with hundreds of names:

Example:

baco
bake
boes

I want it to look like this:

baco01
bake02
boes03

Thanks for your help. Diane

You could use a helper column with the formula

=A1&TEXT(ROW()+1,"000")

which, of course, produces baco001, however you said that you had 'hundreds' so two digits might not be useful, but that is your choice.

to restrict to 2 digits use:

=A1&TEXT(MOD(ROW()+1,100),"00")

Vary the Row()+1 to start at the number desired.

Once generated copy and Paste Special = Values back over the Names column and remove the helper column.


hth
---

Originally Posted by dfarris

I am trying to add increasing numbers to existing column of text with hundreds of names:

Example:

baco
bake
boes

I want it to look like this:

baco01
bake02
boes03

Thanks for your help. Diane

Further amended to:

To generate numbers 1 to 99, generate numbers with
=MOD(ROW()-1,99)+1

If you start at row 2 (wanting number 1) then
=MOD(ROW()-1,99)
etc

---

Originally Posted by Bryan Hessey

You could use a helper column with the formula

=A1&TEXT(ROW()+1,"000")

which, of course, produces baco001, however you said that you had 'hundreds' so two digits might not be useful, but that is your choice.

to restrict to 2 digits use:

=A1&TEXT(MOD(ROW()+1,100),"00")

Vary the Row()+1 to start at the number desired.

Once generated copy and Paste Special = Values back over the Names column and remove the helper column.


hth
---