Hi Peter, PLUSCODE_TO_ADDRESS outputs two columns, with the place name in the second column. Are you seeing Buenos Aires there?
Here's an example (assuming there's a locality table defined in B26:C30): Input Function Output (2 columns) 7JWVJ67W+45 =PLUSCODE_TO_ADDRESS(B35, $B$26:$C$30) J67W+45 Delhi 7HP8PQJG+J5X =PLUSCODE_TO_ADDRESS(B36, $B$26:$C$30) PQJG+J5X Riyadh 8Q7XPWH5+V83 =PLUSCODE_TO_ADDRESS(B37, $B$26:$C$30) PWH5+V83 Tokyo Cheers, Bill On Wed, Aug 24, 2022 at 11:52 AM Peter Drukker <pdruk...@gmail.com> wrote: > Making pluscode in Google Sheets is no problem but... generating a short > Pluscode with the locationname is a problem (for me). > I am making use of the Pluscode-addon in Google Sheets. One of the > functions in this addon is the 'Convert to addresses' option. By using this > function the result of the functions only shows me the 6 first characters > but not the place name : 9HR7+CG Behind CG i am expecting Buenos Aires > because the full Pluscode is 48Q39HR7+CG. > > Is there an option/function/script available to make a simple translation > from the full Pluscode to a short and meaningfull Pluscode including a > locationname? > The short pluscode can be usefull for giving my Points Of Interest > (POI)-files the name of this short pluscode. > > -- > 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-code+unsubscr...@googlegroups.com. > To view this discussion on the web, visit > https://groups.google.com/d/msgid/open-location-code/30bf90c9-c5e3-4126-80b1-6571e0cb86c9n%40googlegroups.com > <https://groups.google.com/d/msgid/open-location-code/30bf90c9-c5e3-4126-80b1-6571e0cb86c9n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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-code+unsubscr...@googlegroups.com. To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/CANaMn1DomSnj%2BghD_giuA9ea5yRb2RNAUmZEyHevJ6tkExK4mw%40mail.gmail.com.
