"forceten32" wrote:
.. 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.

One way which might suffice for the intent indicated ..

Assuming data in A1 down
Put in B1, copy down:
=A1&TEXT(COUNTIF($A$1:A1,A1),"000")

This would yield in col B, for the sample data posted:

aas001
aas002
aas003
aas004
aas005
bbc001
bbc002
bbc003
bbc004
bbc005
etc

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--