how do i get automatically number columns within quotes

R

RevSri

my querry is that i want to gerenate the numbers automatically within the
quotes.(in excel)

For Example:

"load1"
"load2"
"load3"
like this i want to generate it upto "load1000"
 
D

Don Guillett

try this idea

Sub incrementnuminquotes()
For i = 1 To 3
x = """load" & i & """"
MsgBox x
Next i
End Sub
 
R

Roger Govier

Hi
Highlight the three cells, with load1, load2 and load3 in them, and
click on the fill handle (small black cross as you hover over bottom
right of selected range). Hold your left mouse button down as you drag
the mouse down the column as far as required.
The ending number will increment automatically.
 
D

Dom_Ciccone

If you don't want to use VBA, simply use this formula in the Excel cells:

=CHAR(34) & "load" & ROW() & CHAR(34)

Assuming that you want the list to start at row 1 that will work. If you
want it to start at row 5 for example, you'll need to change it to read:

=CHAR(34) & "load" & ROW()-4 & CHAR(34)

Drag fill this formula to complete your set and then copy and paste values
if you wish to remove the formulas.
 
Top