Formula for filling Alphanumeric string that contains 2 sets of numbers

Hi,

I have a string in a single cell "A1":

"<string>Name[1],Value[1]</string>"

How can I increment Name and Value using Fill command?

I need to to go to Name[5000],Value[5000]

For example below:

"<string>Name[1],Value[1]</string>"
"<string>Name[2],Value[2]</string>"
"<string>Name[3],Value[3]</string>"
.
.
.
"<string>Name[5000],Value[5000]</string>"

This formula in cell A1 will begin the list.

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Then, to "hardcode" the values...
• Select the range of formulas
• Copy....Home.Paste.Paste_values over themselves.

Does that help?

=CHAR(34)&"<string>Name["&ROWS(A$1:A1)&"],Value["&ROWS(A$1:A1)&"]</string>"&CHAR(34)

OK...Try this:

Please Login or Register  to view this content.

Copy that down