Results 1 to 6 of 6

Mapping a Google Plus Code but the "+" is omitted when using the hyperlink

Threaded View

  1. 06-10-2022, 08:20 PM #1
    rgoins82
    rgoins82 is offline
    Registered User
    Join Date
    11-07-2020
    Location
    Phoenix, AZ
    MS-Off Ver
    2010 & Office 365
    Posts
    62

    Mapping a Google Plus Code but the "+" is omitted when using the hyperlink

    I have attached a workbook that has a database and includes Google Plus codes. I tried to have a hyperlink to map the location but when I try to use the hyperlink, it omits the "+" in the Google Plus Code making it unable to find the location.

    The function I am using is a simple function: =HYPERLINK("https://maps.google.com/maps?q="&E5,"Map It")

    Please see the attached workbook.

    Any help is appreciated!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Google Sheets Error in formula - =IF(SEARCH(B$1, $A2),"Yes","No")
    By Ian99099 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-31-2021, 07:18 AM
  2. Convert VBA" IF THEN" function into Google Appscript code
    By frnzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-19-2019, 01:52 AM
  3. Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas
    By Windyz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  4. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  5. An exploration in charting and "mapping" -- complex polynomials
    By MrShorty in forum Tips and Tutorials
    Replies: 0
    Last Post: 02-18-2016, 01:32 AM
  6. [SOLVED] Automatically changing screentip for "each"/"every" hyperlink in worksheet?
    By jmccoughlin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2015, 01:03 PM
  7. Run-time error "-2147023783 (80070459": No Mapping for the Unicode character exists...
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2015, 06:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1