Excel Skill (1) -- 判断时如何去掉框里的空格

使用命令 TRIM

 

说明：

  1. Purpose. Remove extra spaces from text.
  2. Text with extra spaces removed.
  3. =TRIM (text)
  4. text - The text from which to remove extra space.
  5. TRIM strips extra spaces from text, leaving only single spaces between words and no space characters at the start or end of the text.

posted on 2016-11-14 15:17  freshair_cn  阅读(175)  评论(0)  编辑  收藏  举报

导航