F
forceten32
I am new to Excel.
I have the following cells in one column in sequential rows:
aas
aas
aas
aas
aas
bbc
bbc
bbc
bbc
bbc
I want to make a command to change these to:
aas001
aas002
aas003
aas004
aas005
bbc101
bbc102
bbc103
bbc104
bbc105
How do I change or rename a series of cells in a column, increasing the
digit by 1 while retaining the three letter prefix? I'm trying to create
product serial numbers in a worksheet with hundreds of rows of products.
Thanks,
Fred
I have the following cells in one column in sequential rows:
aas
aas
aas
aas
aas
bbc
bbc
bbc
bbc
bbc
I want to make a command to change these to:
aas001
aas002
aas003
aas004
aas005
bbc101
bbc102
bbc103
bbc104
bbc105
How do I change or rename a series of cells in a column, increasing the
digit by 1 while retaining the three letter prefix? I'm trying to create
product serial numbers in a worksheet with hundreds of rows of products.
Thanks,
Fred