TRIM Function (Functions in Excel)
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. |
0 comments:
Post a Comment