（最佳）去除/添加空格

风雨云

<p>&nbsp;</p><p></p><p>结果：把A列中的空格数，全部转换为1个，文字部分不变。</p><p>注：各单元格中空格后的文字数均不相等，空格前只有一个文字。数据较多，批量转换。<br/></p><p>结果如下图：</p><p><br/></p>

[此贴子已经被作者于2008-12-8 11:10:44编辑过]

周星弛

不能用公式吗?

xchw1818

游客，如果您要查看本帖隐藏内容请回复

yaoxuejian

<p>不会</p><p>来看</p>

搁浅2008

<p>不会 来学习一下</p>[em01]

zyjs029

<p>=LEFT(A1,FIND(" ",A1)-1)&amp;" "&amp;MID(SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),FIND("/",SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))</p><p>看行么 </p>[em01]期待高手简单的操作

风雨云

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>zyjs029</i>在2008-12-8 11:11:00的发言：</b><br/><p>=LEFT(A1,FIND(" ",A1)-1)&amp;" "&amp;MID(SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),FIND("/",SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(SUBSTITUTE(A1," ","/",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))</p><p>看行么 </p>[em01]期待高手简单的操作</div><p></p>zyjs029兄，如果是没有空格，而需要在第一个文字后面添加一个空格呢？例如：A6

木玉成约

去除空格，简单的可以用=TRIM(A1)

luxueyan2008

<p>这个意思吗</p><p>

游客，如果您要查看本帖隐藏内容请回复

<br/></p>

万杰

<br/>