Replace part of a URL in Excel 2013 with the contents of a cell

[Hentr]

Hi There

I'm stuck...Please help..

I'm a request fulfilment manager, and I have an Excel sheet which is an extract from our Helpdesk system. It's 70.000+ rows. Here is my challenge:

In colum A I have a unique number for the specific Request i.e. RFxxxxx and in colum B I have an URL that I have copied from the browser adressline, but in the URL a specific RFxxxxx number http://hpsm.regsj.intern/sm/index.do?ctx=docEngine&file=request&query=number="RF00021941%22&action=&title=Request%20RF00021941 (this URL is copied to all rows in the spreadsheet)

What I would like to do is to replace the bold text with the data (text) in colum A, whitch is similar in format, how do I do this using VBA or a Macro in all rows, top to bottom?

Kind Regards
Henrik Troels-Hansen

 

[Hentr]

Re: How to replace part of a URL in Excel 2013 with the contents of a cell

Hi Sergio

I found the culpret :O)
In this string: =HYPERLINK("http://hpsm.regsj.intern/sm/index.do?ctx=docEngine@file=request&query=number%3D%22"&A2&"%22&action=&title=Request%20"&A2), there is an @ which should be an &, then it worked like it's supposed to..

Thanks a million for your help and patience..

Kind regards
Henrik Troels-Hansen

 

[sergioMabres]

Re: How to replace part of a URL in Excel 2013 with the contents of a cell

Aways glad to help Hentr!