increment value by 1 for each row
Posted on 2013-01-21
How can I increment a cell value by 1 in each new row?
for example, let's say I have the value DE01 in cell A1. I want to copy that down 500,000 rows and have it increment by 1 on each new row, so cell A2 would be DE02, A3 would be DE03, etc...
How can I do this?