Tuesday, 31 January 2017

How to remove space in excel after text - TRIM

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

Syntax=TRIM(TextToTrim)

Formatting
No special formatting is needed.

No comments:

Post a Comment