Excel Function: TRIM

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…

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.DailyTenMinutes.com

     

--
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