This function is helpful to remove the unnecessary spaces from cell fields…
AB CD ABCD =TRIM(C4)
A B C D ABCD =TRIM(C5)
Alan Jones Alan Jones =TRIM(C6)
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
=TRIM(TextToTrim)
Formatting
No special formatting is needed.
-- Example
Original Text Trimmed Text
AB
A B C D
Alan Jones
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)
No special formatting is needed.
--
To post to this group, send email to keep_mailing@googlegroups.com
---
You received this message because you are subscribed to the Google Groups "keep_mailing" group.
To post to this group, send email to keep_mailing@googlegroups.com.
No comments:
Post a Comment