Forum Discussion
Is It Possible to Fill Series on an Alpha Numeric?
We have a spreadsheet log for our part numbers. The part numbers looks like this:
X100001
Is there a way to fill a series down a column incrementing by 1? I realize that I could make a concatenate, but was hoping for a way to do it in the Fill Series command...
Thank you,
Dan
3 Replies
Name the first cell as X10001 and the cell below it as X10002, select both cell and double click the auto fill or drag it downwards fill the number of rows needed
IMHO, one cell is enough for that
- Hello,
Fill Series doesn't support alphanumeric values... It only allows integers or decimal number...
You can use a normal formula to do what you intend to
