In column A of sheet 2 (sheet2.A), I’d like to use a formula with two functions:

- reference column A of sheet 1 (=$sheet1.A:$sheet1.A)
- apply the TRIM function to its cells

Is it possible to do this with one single formula, and if so, what would it be?