How to remove leading or trailing spaces in an entire column of excel worksheet in Excel2010 – Stack Overflow. If you would like to use a formula, the TRIM function will do exactly what you’re looking for: +—+———–+——————–+ |   | A         | B                  | +—+———–+——————–+ | 1 | =TRIM(B1) | value to trim here | […]