（最佳）去除/添加空格

苹果和香蕉

想看看

木玉成约

=IF(MID(A1,2,1)<>" ",REPLACE(A1,2,," "),TRIM(A1))，应该可以吧

hingkk

学习下，看看<strong><font face="Verdana" color="#000000" size="1">luxueyan2008的答案</font></strong>

hyj8311

学习学习

goo

[em01]学习 看看

zyjs029

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>风雨云</i>在2008-12-8 11:17:00的发言：</b><br/><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</div><p><strong><em>风雨云&nbsp; 兄&nbsp; 请把你的原文件上传下。刚才没看到你要求的结果&nbsp; 以为只是中间要一个空格呢</em></strong></p>

wxj1126

<p>好难啊，来学习一下</p>

qinqh_yl

=LEFT(A1)&amp;" "&amp;TRIM(MID(A1,2,99))

花木兰

来学习了[em01]

zyjs029

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>qinqh_yl</i>在2008-12-8 11:57:00的发言：</b><br/>=LEFT(A1)&amp;" "&amp;TRIM(MID(A1,2,99))</div><p>高&nbsp;&nbsp; 简洁 </p>[em17]