删除整列数据中的前导或尾随空格 [英] Remove leading or trailing spaces in an entire column of data

问题描述

如何删除整列中所有单元格的前导或尾随空格?

How do I remove leading or trailing spaces of all cells in an entire column?

工作表的传统Find and Replace(又名Ctrl+H)对话框没有解决问题.

The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

推荐答案

如果您想使用公式，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...

这篇关于删除整列数据中的前导或尾随空格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！