0

I am importing data from another workbook, but some of the data have extra spaces at the start or end. I am looking for a way to TRIM the IMPORTRANGE data.

player0
  • 124,011
  • 12
  • 67
  • 124
Ralph C
  • 47
  • 1
  • 7

1 Answers1

1

your formula should be like:

=ARRAYFORMULA(TRIM(IMPORTRANGE("ID"; "SheetName!A1:D20")))
player0
  • 124,011
  • 12
  • 67
  • 124