New answers tagged google
4
votes
Accepted
Text result of JOIN is longer than the limit of 50000 characters
Use a query smush, like this:
=arrayformula(
substitute(
transpose(
split(
query(
filter(
substitute( substitute(Data!C2:C, " ", "_")...
Top 50 recent answers are included
Related Tags
google × 326google-sheets × 54
gmail × 49
google-drive × 30
google-apps × 19
google-calendar × 16
google-plus × 16
google-analytics × 12
formulas × 11
youtube × 11
google-chrome × 10
account-management × 10
authentication × 10
google-account × 9
security × 9
google-docs × 8
google-search × 8
privacy × 8
google-contacts × 8
localization × 8
search-engine × 8
google-maps × 7
facebook × 6
trello × 6
google-sheets-query × 6