What is the simplest way to extract text pattern in Excel spreadsheet?

I have a sheet of a few columns of URLs. I need to extract a text pattern (I.E. extracting an URL parameter) and then replace it with something else and place it into another link structure. What's the simplest way to do that in Microsoft Excel spreadsheet? Does Excel provide regular express?
Update: In my specific case, the scenario would be a conversion from Origin URL to Destination URL with the same "l=xxx" parameter. Orgin... show more In my specific case, the scenario would be a conversion from Origin URL to Destination URL with the same "l=xxx" parameter.

Orgin URL:
http://app.advertising.com/3/c/router.aspx?p=12345678{ifsearch:220012}{ifcontent:888}&kw={ifsearch:{keyword}}{ifcontent:top_3}&cr=07819_Control&adid={creative}&l=3499&channel=google

Destination URL:
http://www.example.com/find/BrowseLeads?l=3499&channel=google1

in which, "?l=xxxxxx" is the variable length parameter that would be carried along in the destination URL.

Since both URL with parameters are variable length, is there a good way to achieve this?
4 answers 4