How to remove space in excel after text
TRIM
Original Text
|
Trimmed Text
|
|
ABCD
|
ABCD
|
=TRIM(B2)
|
A B C
D
|
A B C D
|
=TRIM(B3)
|
Alan Jones
|
Alan Jones
|
=TRIM(B4)
|
ABCD
|
ABCD
|
=TRIM(B5)
|
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
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.