[www.keralites.net] Excel Function: TRIM

 

This function is helpful to remove the unnecessary spaces from cell fields…

Example

Original Text

Trimmed Text

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

 

Syntax

=TRIM(TextToTrim)

 

Formatting

No special formatting is needed.

M Junaid Tahir

---

www.keralites.net

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 44

Visit Your Group

KERALITES - A moderated eGroup exclusively for Keralites...
To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: www.keralites.net

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___