About Replace with Increment

If you select the Increment by checkbox and type values in the Replace with and Increment by boxes, you can quickly create similar items in sequence. If you select the Increment by checkbox, make sure you type only numeric data in the Replace with and Increment by boxes.

Wall Stud Increment Example

Assume you need to make a series of 2x4 wall studs varying in length from 8 to 24 feet with 2 feet being the difference between each stud.

1. Create a template wall stud. Type unique characters that represent the number you want to increment. For example, type 2x4x@@@ #1 Stud where "@@@" represents the number to increment.
2. Use Repeat to create 9 items.

3. Select the cells.

   Be sure that the top cell in the selection is the current cell by pressing Ctrl when you click the first cell in the sequence and while you extend your selection.

4. Type @@@ in the Find box.
5. Type 8 in the Replace with box.
6. Click Selection in the Look in list.
7. Select the Increment by checkbox.
8. Type 2 in the Increment by box.
9. Click [Replace All].