Trim Formula


1. TRIM 

TRIM strips extra spaces from text, leaving only single spaces between words and no space characters at the start or end of the text. TRIM is useful when cleaning up text that has come from other applications or environments.

Example:

=TRIM(text)

=TRIM(C3)



2. TRIM



 

No comments:

Post a Comment