google sheets and 3 digits after +

[philippe titivi]

Hi all,

I want 3 digits after the "+" in a google sheet cell but without using the "add-on".

with: =PLUSCODE(myLat:mylng) I only get 2

Thanks :-)

[Barry Hunter]

I found the help page for the add-on in the the Wayback Machine, as it seems to be offline, the page as https://plus.codes/spreadsheet-add-on redirects to a new homepage. 

https://web.archive.org/web/20191222034619/https://plus.codes/spreadsheet-add-on

Seems the PLUSCODE function accepts (or did!) optional Length param...

• =PLUSCODE(location_range, [length])

• length is optional and sets the length of the code. If not specified, codes of length 10 will be returned. If it is specified it must be an even number less than 10, or any number between 10 and 16.

... so it seems should be able to do =PLUSCODE(myLat:mylng, 11)

As you want 3 after the + which is after 8. 

--
Public site: http://www.openlocationcode.com/
Github project: https://github.com/google/open-location-code
Demo site: http://plus.codes/
---
You received this message because you are subscribed to the Google Groups "Plus Codes Community Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to open-location-c...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/de1934ea-e7e6-4223-90da-f2bf16fc936bn%40googlegroups.com.

[philippe titivi]

Thank you very much for this quick response @barryb...
I had tried 3 then 4... but hadn't thought of trying 11 !!!

If it doesn't work any better...  you gave me some courage ;)

The solution (found by trial and error) is:    =PLUSCODE(A22:B22;11)