how do i get automatically number columns within quotes

[Guest]

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"

 

[Don Guillett]

try this idea

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

 

[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.

 

[Guest]

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.

 

[Don Guillett]

or
="" & "load" & ROW() & ""