如果您想使用公式，TRIM 函数将完全满足您的要求:

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 |
+----+------------+---------------------+

所以要做整列...
1) 插入一列
2) 插入 TRIM 函数指向您要更正的单元格.
3) 在页面下方复制公式
4) 复制插入的列
5)粘贴为值"

So to do the whole column...
1) Insert a column
2) Insert TRIM function pointed at cell you are trying to correct.
3) Copy formula down the page
4) Copy inserted column
5) Paste as "Values"

从那里开始应该很好......

Should be good to go from there...