TRIM ()
This function removes unwanted or extra spaces from text.
The spaces before and after the text will be removed
completely. Multiple spaces within the text will be trimmed to a single space.
Best view in desktop mode.
A
|
B
|
C
|
D
|
|
1
|
Original Text
|
Trimmed Text
|
||
2
|
Peter Parker
|
Peter Parker
|
=TRIM(A2)
|
|
3
|
AB CD E F
|
AB CD E F
|
=TRIM(A3)
|
|
4
|
a b c
d
|
a b c d
|
=TRIM(A4)
|
|
5
|
Thanos
|
Thanos
|
=TRIM(A5)
|
|
6
|
1 3 4 5
|
1 3 4 5
|
=TRIM(A6)
|
|
7
|
Syntax
=TRIM(Text)
Formatting
No special
formatting is needed.
No comments:
Post a Comment