Log in

View Full Version : Recoding URL string variable


sricharan10
Mar 20, 2013, 09:12 AM
How do I recode a URL string variable? For example one of the variables is a url. If I find the word download anywhere in the url I want to recode that into download center. How do I do this?

ebaines
Mar 20, 2013, 11:46 AM
You can use the FIND() function in excel to see if the string "download" appears in the URL string. The following would return "Download Center" if cell A1 contains the string "download" anywher in it, or simply copy over the URL string if "download" is not present:

=IF(ISNUMBER(FIND("download",A1)),"Download Center",A1)