30 excel functions in 30 days - TRIM Function

1705 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: 372 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

 

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 29 June 2026
Article Assistant

Alvino Consultancy LLP

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details