4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

Excel field to website store finder??? Anyone???

by goindeep
3 replies
Hi all


We use an excel sheet which has a post code cell section (zip code in USA).

We want the bottom of the sheet to source the cell data (3977) migrate it into the url and then issue a hyperlink straight to our third party store finder and search for the postcode. We have built the string with = " " " in the correct spots but because of the string the hyperlink wont open in the browser, We cant figure out a way around this yet.

Any ideas?
#excel #field #finder #store #website
  • Profile picture of the author Unomateo
    Are you saying it won't open because of spaces in the string?

    if so, fill all the spaces with %20 with a string replace
    {{ DiscussionBoard.errors[4726639].message }}
    • Profile picture of the author goindeep
      Originally Posted by Unomateo View Post

      Are you saying it won't open because of spaces in the string?

      if so, fill all the spaces with %20 with a string replace
      No, its basically the quotation marks in front and at end are preventing it from opening.
      {{ DiscussionBoard.errors[4726904].message }}
      • Profile picture of the author alexylee
        Question mark has special meaning in URL.
        The string after question mark is considered as parameter list.
        Probably you need to remove ? mark in url.
        {{ DiscussionBoard.errors[4727109].message }}

Trending Topics