banner_ad

30 excel functions in 30 days - TRIM Function

Others 1699 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: 370 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
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
23 May 2026
Account 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
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details