increase number in cell by one continuously...

[urlocaljeweler]

I am using Excel 2007...

I have a column with rows such as follows;

store.murpheythejeweler.com/store/p/7055-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7056-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7057-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7058-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7059-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7060-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7061-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7062-Tungsten-Flat-8mm-Polished-Band.aspx

I need to copy and paste this into new cells but I need the numbers to add to
one another so I do not have to manually go in and add one number to each
paste.

For example-- I have this;
store.murpheythejeweler.com/store/p/7062-Tungsten-Flat-8mm-Polished-Band.aspx

Now I need to copy and paste 100 more of that with a change to all of
the 100 pastes to have one more number than the previous paste; (7062, 7063,
7064, 7065, 7066, 7067 etc...

Any help is much appreciated!

 

[Ms-Exl-Learner]

Just copy and paste the below formula in any of the cell

="store.murpheythejeweler.com/store/p/"&7062+ROW(A1)&"-Tungsten-Flat-8mm-Polished-Band.aspx"

Now place the cursor on the pasted cell and drag it for the remaining cells.

Or

Copy that cell and paste it for the remaining cells.

If this post helps, Click Yes!

 

[Timbo]

Type this into A1 - store.murpheythejeweler.com/store/p/

Type this into F1 - 7055
Type this into F2 - 7056

Type this into G1 -

Type this into H1 Tungsten-Flat-8mm-Polished-Band.aspx

Select F1:F2

Click the box in the bottom right hand corner and drag down the page

Copy A1, G1 and H1 down the page to where you stopped copting you
numbers in column F.

In Q1 type =concatenate(A1,F1,G1,H1)

Copy that cell down and the number will change for you.

Copy and paste as values and you can past it wherever you want and i
won't change.

A bit of a faff but to my knowledge you can't change the number in th
middle of a line of text.

You can probably do it with a macro but I can't help you there