adding to certain characters/numbers in multiple rows in certain a

U

urlocaljeweler

I have these rows etc...
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 add onto
each other so I do not have to manually go in and add 1 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. Now I need to change all of
those 100 pastes to have new numbers, 1 more than the previous; (7062, 7063,
7064, 7065, 7066, 7067 etc...

Any help is much appreciated!
 
K

KARL DEWEY

You stated 'rows' and 'cells' wich are Execl terms. Is your data in Excel or
Access?

If you are working in Access where are the separators or is everything all
in one field?
 
U

urlocaljeweler

Thank you for your response. I am working in Excel, although I believe that
Access may be beneficial to learn. I have been taking the online tutorials
for Access, but have yet to be able to figure out how to make it benefit my
product details.csv's...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top