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