Im trying to make a spreadsheet that contains about 250 product items. In column "A" is the product code, such as 1243, aribat, 3459, tent22, etc. Column B needs to be the URL of the code which is set in the format of:
http://www.mysite.com/1243.html,
http://www.mysite.com/aribat.html,
http://www.mysite.com/3459.html, etc.
I can copy all the cells of colum A into Colum B to have the unique codes in column B, but is there a macro or a way of adding wildcards or something to that code so I can add the
http://www.mysite.com/ in front of the code and .html behind it so I have the full URL?
The codes in colum A are mixed. Some codes are 4 numbers long, others are 5 and 6 and still others are words...they are uniquely generated by some software. It seems like it should be easy to use something like Word's "Find and Replace" features but the codes are different character lengths and I need to add .html after it.
I hope you understand what Im trying to do. Just post if you need clarification.
Thanks!
Phil
Start Free Trial
