Excel Skill (1) -- 判断时如何去掉框里的空格
使用命令 TRIM
说明:
- Purpose. Remove extra spaces from text.
- Text with extra spaces removed.
- =TRIM (text)
- text - The text from which to remove extra space.
- 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 阅读(174) 评论(0) 编辑 收藏 举报