Trim
The
Trim function returns a text value with the leading and trailing spaces removed.
Example: = Trim (A1)
Substitute
Substitute function replaces a set of characters with another.
Example: =SUBSTITUTE(A1," ","") could be used for removing the spaces inside the cell.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12374161/viewspace-666797/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12374161/viewspace-666797/