On Tue, Apr 16, 2013 at 10:50 AM, Junaid Tahir <mjunaidtahir@gmail.com> wrote:
This function is helpful to remove the unnecessary spaces from cell fields…--ExampleOriginal TextTrimmed Text
ABCDABCD=TRIM(C4)
A B C DABCD=TRIM(C5)
Alan JonesAlan 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.
You received this message because you are subscribed to the Google Groups "Islamabadianz" group.
To unsubscribe from this group and stop receiving emails from it, send an email to islamabadianz+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Need Your Comments.....!
For University of Pakistan Study Material Sharing, Discussion, etc, Come and join us at http://4e542a34.linkbucks.com
You received this message because you are subscribed to the Google
Groups "Study" group.
To post to this group, send email to http://ca13054d.tinylinks.co
For more options, visit this group at
http://004bbb67.any.gs
No comments:
Post a Comment
Note: only a member of this blog may post a comment.