|
Original Text
|
Trimmed Text
|
|||||||
|
ABCD
|
ABCD
|
=TRIM(C4)
|
||||||
|
A
B C D
|
A B C D
|
=TRIM(C5)
|
||||||
|
Alan
Jones
|
Alan Jones
|
=TRIM(C6)
|
||||||
|
ABCD
|
ABCD
|
=TRIM(C7)
|
||||||
|
What Does It Do ?
|
|
|
|
|
|
|
||
|
This function removes unwanted
spaces from a piece of text.
|
||||||||
|
The spaces before and after the
text will be removed completely.
|
||||||||
|
Multiple spaces within the text
will be trimmed to a single space
|
||||||||
|
Syntax
|
|
|
|
|
|
|
|
|
|
=TRIM(TextToTrim)
|
||||||||
|
Formatting
|
|
|
|
|
|
|
||
|
No special formatting is needed.
|
||||||||
Monday, 16 September 2013
TRIM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment