Hi Can anyone provide a vba to convert the following:
Cell A1 Value = Lemon, Mango, Apple, Banana
into
Cell B1 Value = 1. Lemon, 2. Mango, 3. Apple, 4. Banana
Cell A1 Value = Lemon, Mango, Apple, Banana
into
Cell B1 Value = 1. Lemon, 2. Mango, 3. Apple, 4. Banana
Automatic serial number in Excel VBA
Generate Serial Numbers by Adding One in the Previous Number
Enter 1 in the cell from where you want to start your serial numbers.
In next down cell, enter formula =G1+1 (G1 is the starting cell here).
Drag this formula to down, up to the serial numbers you want.
Generate Serial Numbers by Adding One in the Previous Number
Enter 1 in the cell from where you want to start your serial numbers.
In next down cell, enter formula =G1+1 (G1 is the starting cell here).
Drag this formula to down, up to the serial numbers you want.
- Page :
- 1
There are no replies made for this post yet.