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!!

I was under the impression that you have to give town and state as well as plus code. And in formulas, convert the "+" to %2B ... so, like: =HYPERLINK("https://maps.google.com/maps?q="&SUBSTITUTE([@[Google Plus Code]],"+","%2B")&MID([@Address],FIND(",",[@Address]),99),"Map It")

Thank you! This worked for all but two dealerships. (Autonation Ford & Van Chevrolet). These two came back with a #VALUE! error, stating that the data was the wrong data type. Very odd to me. These two dealerships are side by side of each other (Basically in the same parking lot). Can you see why it might have this error? If there isn't a fix, I'm okay with it. I have hundreds of dealerships to add to this list. (I run a logistics company that delivers Auto Parts). Again! Thank you so much for your time and help to solve my problem. Based on your formula, I would have NEVER, EVER figured it out! Cheers from Phoenix, AZ (It is 45.5 celsius today!)

I notice that 2 in that list have no Town, State ... being:
Location Address
AutoNation Ford 8555 E Frank Lloyd Wright Blvd
Van Chevrolet 8585 E Frank Lloyd Wright Blvd
.. so if you either add ", Scottsdale, AZ" to the end of those addresses, or adjust the formula to do some trickery when the town and state are missing, and it should be fine.

Great Eye! You're correct, once again. That fixed my problem. Much appreciated!

Rob

My pleasure

Cheers, Glenn