30 excel functions in 30 days - TRIM Function

1630 views 3 replies

I will be taking you to a simple guide on 30 Functions in my post's here.... So here is begin first function below:

TRIM:

The TRIM function removes all the spaces in a text string, except for single spaces between words.The TRIM function can help with the cleanup of text that you've downloaded from a website, or imported from another application. The TRIM function:

  • Removes spaces from start and end of text string
  • Removes all except single spaces between words
  • Does NOT remove some special space characters copied from websites

Refer Attached file.


Attached File : 25603 1068083 30fn30d trim function.xlsx downloaded: 334 times
Replies (3)

Very Good Move Sir......... It will be beneficial for all of us.Thanks for starting this series.Looking forward for 2nd part.....

a very good step sir..keep going...

Dear sir,

 

Excellent this is working 

Regards

Ramesha.m

 

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register