Monday, 15 April 2013

[HM:255954] Excel Function: TRIM

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


Original Text
Trimmed Text


 A   B   C   D

 Alan   Jones
Alan Jones

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




No special formatting is needed.

M Junaid Tahir
Blogger Twitter LinkedIn  Google Plus Blog RSS

We are also on Face Book, Click on Like to jois us
FB Page:
FB Group:
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
For more options, visit

No comments:

Post a Comment