Search code examples
splitgoogle-sheets-formula

Combine Importrange with Split function in Google Sheets


I'm trying to split an import range function but it seems to only work on a single entry and not the full length of the importrange. Not sure how to fix this.

=SPLIT(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1JXndR39CPynbs0XVsXPWClcjuUh81BGUM6TvfOys7mA/edit";"Mappen & Bestanden!A2:A");"/-_")

Hoping for some advice

Thx!


Solution

  • Try

    =ARRAYFORMULA(SPLIT(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1JXndR39CPynbs0XVsXPWClcjuUh81BGUM6TvfOys7mA/edit";"Mappen & Bestanden!A2:A");"/-_"))