Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Recoding URL string variable (https://www.askmehelpdesk.com/showthread.php?t=740101)

  • Mar 20, 2013, 09:12 AM
    sricharan10
    Recoding URL string variable
    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?
  • Mar 20, 2013, 11:46 AM
    ebaines
    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)

  • All times are GMT -7. The time now is 02:52 PM.