Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 06 May 2020
  1 Replies
  8.1K Visits
Hi Can anyone provide a vba to convert the following:

Cell A1 Value = Lemon, Mango, Apple, Banana


Cell B1 Value = 1. Lemon, 2. Mango, 3. Apple, 4. Banana
3 years ago
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.
  • Page :
  • 1
There are no replies made for this post yet.