banner_ad

30 excel functions in 30 days - TRIM Function

Others 1697 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: 369 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  

Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details