=TRIMALL({" a ";"b ";" c "})
-> {"a";"b";"c"}
DEFINE(
TRIMALL,
LAMBDA(
range,
MAKEARRAY(
ROWS(range),
COLUMNS(range),
LAMBDA(
row,
col,
TRIM(
INDEX(
range,
row,
col))))))
Help us optimize this function